o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Force 2 lines... -

In Access...

I have a table with accounts , debit/credit, amount

I need to show a debit and credit line for each account even if there is no debit/ credit

Example:


12345 Debit $10
12345 Credit $-12

23411 Debit $6 <- I need to show 23411 Credit $0 also

24455 Debit $1
24455 Credit $-3

understand?

I cant create a table with all accounts with a debit / credit line because there are over 150k lines

how can I bump this up to another table or join etc....to force it?

thanks!

 

Flexgrid - word wrap woes -
I've got a flexgrid with WordWrap set to True. I place two lines of data in a cell, separated with a carraige return (I've tried vbNewline, vbCrLf, and Chr(13) & Chr(10)). The cell is high enough to display the multiple lines. However the results are "hit or miss". Som

[ignore] How do I print -
I got a objprintDiloag and a objPrintDocument. I got a string called sPrint with vbCrLf... How do I send that to the printer? I have been trying to figure it out, but the book I am reading is trying to teach it to me in a 106 lines (???? I think I did it in vb6 in like 5 lines on

Event code causing screen problems -
I'm doing some 'Worksheet_Change' event coding and I think I'm close to what I need except that when the code finishes, some of the grid lines on some of the cells on the screen and even some of the cell values become invisible. To get them back, I need to either manually deactivate a

Line above anything else -
I have created few new lines using control array (you know using load thing). It works fine except that my line is always on the back of the label (obviously it should be on the front). Do you know how to force these stupid lines to be on the front?? Thanks for your help. ------------

Help: Project on Force feedback joystick -
Hi I am doing a project on Force feedback joystick (Microsoft Sidewinder 2) using VB 6.0. I was able to enumerate the device and initialize a constant force constINF.ffe but I was not able to modify that force. How can I do that?

help with Foematting uppercase -
I use this - sInput2 = UCase(Mid(sInput2, 1, 1)) + LCase(Mid(sInput2, 2)) to force upercase on first two characters of text in customer number eg db1234 to go DB1234 Does any one know how to force input like new york to force the N and Y to uppercase. N is ease but I can't managed

Force 2 lines... -
In Access... I have a table with accounts , debit/credit, amount I need to show a debit and credit line for each account even if there is no debit/ credit Example: 12345 Debit $10 12345 Credit $-12 23411 Debit $6 <- I need to show 23411 Credit $0 also 24455 D

nooby 3d Vector question - [resolved] -
I have a particle (P), with an (x,y,z) position and a [x,y,z] vector that represents its current direction and speed. The particle has mass M. I want to impart a force on the particle. The force (F) has the vector [a,b,c] Mass is in Kg, Force is in Newtons. How do I calculat

constructor code -
Hello I have been reading a java a book. and the writer puts a lot of code in his constructors. Can someone tell me if this is good practice. An example is below. I thought that constructors were just for initializing variables, and should not include a lots of code. Maybe l am

Force to escape gravity -
How would i calculate the force needed to escape earths gravity, if i have the x mass of an object? I think i would need two vectors, one for force and one for gravity. maybe one for acceleration too? thanks

The 3rd law of motion is confusing. -
This is not a big philosophical question or anything, I'm just a little confused in my physics class. A good question arose in the text book, and I don't know how to answer it. Newton's 3rd law, as everyone knows, is "For every action there is an equal but opposite reaction."

Force a copy file -
How do I force my app to copy a file? I'm checking the file versions, and some of them are in the system32 folder, which probably means they're being used. I want to force the files to be copied over (for a setup program). I know MS reboots the PC for this to take effect, but I'v

force click in vb.net -
how do i force a left/right click of a mouse in a vb.net prgm. ex) for a desktop cleanup prgm example set mouse location at point x then force a right click move mouse down 100 or so pixels then force a left click

How to Force a specified number of of rows in detail section. -
Forcing a specified number of of rows in detail section. I am using DATA Report Designer as a reporting tool with VB 6.0. I am reproducing an official form that will be filled with data from a database. For this particular form I need the boxes and labels in the details secti

force wrap in dg -
ok ive posted a few times with questions about my dg and such and i was wondering if there was a way to force a dg to wrap when it sees the " / " char, or if there was just a way to force it to wrap the text in a dg datacell. because im developing an update application

Force distribution over the shell of an egg -
Some of you may not know this... if you take a chicken egg and press it with all the force you can at the top and the bottom (lengthwise stress), the egg will not break. This is because the shape of the egg allows for compressive stress forces to be distributed properly along the leng

Force Log Off From VB -
Does anybody know of any VB code that will force a log off of a users id from a given NT server? All help and comments appreciated. Lee

How do you force a tab -
I have a form with two text boxes. If you are typing in the first one and you hit a certain length, I want to force a tab to the next textbox. Any ideas?

"no new operations can begin until the current operation ends" -
I'm trying to port this PoS over to use Oracle. It is a crappy project full of globals variables, but some how they kludged it to work with Access and SQL Server. But now I get this error if I trigger certain events in the right order. How can I force a DB operation to end (clear

Timer stuff -
Is there a way to reset the timer interval without waiting for the full interval the elaps before the changes are made? First i tried tmr.Enable = False tmr.Enable = True However, I found that this only works some times but not all the time... and now for some odd reason,

Super fast square root approximation -
Just as the title says. I'm doing a force mapping function, which works very well, but is slower than I'd like. Right now, I'm forced to use Math.Sqrt for every force point on the map, then once more to get total force out of the X and Y vectors... and this is done for every pixel on a

Some basic bouncing -
F=ma a=F/m I hit the ground with a velocity on the y axis of 50 m/s. Accelerating simply with gravity (9.81) Newtons third law, any force has an equal opposing force. So I hit the ground going 50m/s, for some basic bouncing (very basic) shouldn't I be able to take the current ve

Ques for US types re the name 'Air Force One' -
I've always understood that 'Air Force One' is not the designation of a physical USAF aircraft, but the designation of the aircraft in which the US President happens to be in, at a point in time. Thus although his normal plane might be a B747, if he went for a 'flip' in old WWII C-47 b

[2008] A label with a mutliline paragraph -
Hi, I have a label on my form but when you type in the text it all stays on one line. So i set its max size to force it to tab the text but it only shows two lines. How do i set it to allow me to enter numerous lines of text and display them on seperate lines. So if i type

Refreshing lines -
Hello peeps, I have a number of lines on my form, which when I drag & drop a graphic over, tends to destroy the edges of the lines (which from the border). Can I periodcally refresh these lines.

force actual RAm -
The problem I am having is that my program is not utilizing the available ram. It puts atleast half of the data into the virtual memory. I have a GB of RAM and the total usage is about 512MB combined. Is there a way to force it to use RAM instead?

Is there a way to force.... -
Im trying to figure out if there is a way to force text onto the 2nd line of a label or not. example: on the first line of a label it says something like "First name: blah blah" but there are two names being displayed... Instead of the second name being displayed right af

Force - Opens with: -
Force - Opens with: Hi I need 2 force "Opens with:" my_program (with code) Right Mouse button ==> Properties ==> Opens with:..Replace 2 my program How do i do that? Just that not register (the program is register) Thank you. imosha

force mouse up -
How would you force the mouse up. Hehe not physically force it but at least fire the event that happens when the mouse goes up. If you were to move a form close to the edge of the screen and then "snap" it to the edge, could you make it so the user is no longer dragging the

clicking in vb.net -
how do i force a left/right click of a mouse in a vb.net prgm. ex) for a desktop cleanup prgm example set mouse location at point x then force a right click move mouse down 100 or so pixels then force a left click

ASP.NET Need to Refresh dataset on a postback -
I am running into an odd problem. Apparently I need to force a requerying of the database. I have a constraint that ID = the value in a text box. When I change this text and do a postback, the data in the record set is still the same. If I force another postback, the data is updated. I

Intersecting Lines in 3D -
Hi all, If you look at the pic below I have two lines in 3D that pass over each other. I want to calculate the point shown by the blue cross. This is halfway between the two lines in the z axis. When the two lines cross they have the same x and y values but not z. The vectors

To all API GURUs -
i know the code on how to force a standby mode the problem is that i don't know how to force a un-standby. can you help me.. or is this possible.. i think it is. this is urgent. i have to finish this one or else my ass will be kicked out of service.. thanks in advance!!

Getting # of lines within a textfile -
lets say in C:\text.txt i have the alphabet a-z. each letter is in a different line. now, how would i make the program tell me how many lines are in the file? please note, the file's lines will change, so its not just reading 26 lines, its reading as many lines that are in the file wit

List View Force Rows -
listview controls seem to always want to scroll left and right, i want to force the listview to only have a single column full of images and allow verticle scrolling

XP: Force User Logon -
I want to force users to have to login at the prompt on my computer. Currently, if you just press "Okay" without enterting in a username and password, it'll let you pass. I don't want this to happen. Is there anything I can do?

Excel 2007 msoFileDialogSaveAs force ext -
Is there a way to force an extension (e.g. *.xlsm) on the dialog box when using msoFileDialogSaveAs? Thanks.

Removing lines from the top of a TextBox -
I am writing a telnet client and must set a maximum of lines in the main RichTextBox. The RichTextBox.Lines property does not seem to contain any property or method to delete actual lines of text. Is there any way to remove entire lines from the top of the text box?

Reasonable force -
The situation: You're walking to the taxi rank from the nightclub you just got kicked out of. You take the shortcut through the estate and some dude with a knife jumps you and demands your mobile phone & wallet. The guy is within arms reach and the knife is an average swiss

Force a window frame to repaint -
Does anyone know how to force the border of a window to redraw itself? Thanks MAP