Search results for query: *

Lonnie, What about this? What if I had a column in my table called ID and I made ID=001, 002,.... Then when the record displays the first TB to get the focus was Last Name. When Last Name gets the focus which is immediately, I let Account Number=Last Name(from form)&ID(from table). That way...

You are 100% correct. Only when I create this in the expression builder it changes it to =[Account Number]=[Last Name]&[Account Number], and it doesn't concatenate it. In fact it just leaves there what is originally there. In this case it's the number already assigned to it 001, 002, so on and...

no error message just keep what was originally there, there. Which in this case for the first record was 001. By control source you mean..... I went to the properties of the textbox/event tab/ ongotfocus and created in expression builder. =[Last Name]&[Account Number] All textboxes were...

OK. I think I'm going crazy. I have been spending all day trying to figure this out, but all the whitepapers and all the books in the world aren't helping. Here is how my db is set up: I have a form with textboxes linked to those on a table. It is a client table. To have this table linked with...

thanks john. let me throw this out there as well. each page number has certain account numbers associated with it as well. I need to seperate pages and row will be a header with the account numbers. I have a worksheet for each page with the account numbers in row 1 across the top. I will take...

I pretty good with the basics of Excel. My boss has me doing something now, i'm not experienced doing. Here is what I need: I have a monthly .txt file. I import the information into excel. One column has a page number. I sort by that column. I have a worksheet for each page number. I need to...

dim as a string?

I don't want to set this up as a macro. I would like to write a line to prompt a user to save a form as .xls. Here is where I am: docmd.OutputTo(acOutputForm,New Contract,(*.xls)) it's looking for an (=) sign somwhere. Where am I wrong.

Actually I found this code on microsofts website but I am still having trouble having the user input a time. I think I nees to use TimeValue() and not inputbox(), correct? Function ElapsedTime(endTime As Date, startTime As Date) Dim strOutput As String Dim Interval As Date '...

so instead of inputbox() i use timevalue()? I also hardcoded for the length of time to equal the difference in hours. Should this still work with the possability of a time not on the hour? If txtStart = 12 Then txtLength = txtEnd & "Hours" ElseIf txtStart < txtEnd Then txtLength =...

I am attempting to pass time as a variable. The textbox on the form that the time will be passed into is set to short time. I use input box to get the time from the user like this starttime=inputbox("Enter Time"). Regardless of what is entered the time plugged into the forms' textbox looks like...

I very rarely work with checkboxes what is the value considered. For example if a check box or radio button is selected i'm checking If chkbox.(value)=** then I thought it was enabled but I was wrong

I get a .pdf document once a month about 55-60 pages in length on average. I need for each page to be saved in .pdf format in a different folder on the same network drive. Which folder it is saved to depends on which car dealership location it is. I can manually export one page at a time, but...

So the module should start like so: Public Sub btnNext2_Click() Public LASTNAME As String

Hey guys. It's been a while since I've done this. Can somebody please provide me with the correct coding to populate a variable that can be used on another form. I know that I have to dim it at the module level and make that module public, but I can't remember what the coding looks like. Thanks

NM figured it out

I would like to write a Do Until loop that asks an input box to ask a question until only a 1 or a 2 are entered? I think mycoding is wrong. Here is what I have do until number="1" or "2" NUMBER=inputbox("Please press 1 or 2") LOOP