Search results

wow! about a half hour after I left this message I figured out what the problem was and I was bracing for a lot of flack from here. If you look closer the MAIN problem was that I was using IFF not IIF! dah! but no one else caught it either<grin>. After that I ran into the other problem of using...

I'm trying to add a 0 to the front of a date field (in text format) if the length is 7. In otehr words if the date is 8172001 I need to add a 0 to I can add two /s after that. What's wrong with this formula? iff(Len([Date In]=7),0+[Date In],[Date In])

Joey: That was it. The final product looks like this: If Len(Me.OpenArgs) Then Me.RecordSource = OpenArgs If Me.RecordsetClone.RecordCount = 0 Then MsgBox " No Records Found" End If End If Thanks again

Initially I don't think this is what I'm looking for but I'll give it a shot. Thanks

very slick, thanks

can you set the tab order so it will go to a textbox on teh next tab? OR you can try putting txtNextTextBox.SetFocus (where txtNextTextBox is the textbox you want the focus to go to on the second tab) in the OnClick event (or somewhere) of the last textbox of the first tab.

how about having the calendar's visible property set to no and have a small button that says calendar that toggles the calendar's visible property off and on

I have the following code. I would like to know how I can add a message box that will tell me/the user if no records are found rather than open the display/results form. Private Sub Command16_Click() Dim strSource As String strSource = "SELECT * FROM [Adminstration]" & _ "where...

I looked up Createtable and Type Property but I didn't see and Autonumber example. Can it be done on the fly using code?

I need to find a record and move back one record. The code I have listed below works great but sometimes the previous record doesn't have an address in the [Address] field so I need to move back one more record. I've been playing with the code listed below to see if I can say 'if the [Address]...

>>are you trying to view/update data via a form no, I was trying to order the table by a field. I went into the table, clicked on the field title, then clicked on the down arrow icon up on the menu bar. When I'm through tweaking the table I imported from a spreadsheet, I import it into the main...

I have the following SQL statement, but when I click the button it's on I get an error saying I need an SQL statement to use RunSQL. What's wrong with the SQL I have? How do I put the table in order byt that field? Dim STRField As String STRField = "SELECT * " & _ "FROM [APS Import...

I know how to create a new numeric field but how can I fill it with numbers from 1 to what ever the highest number is?

hmmmm, doesn't each record have a number? can't I find the record with the data, put that record number into a variable and then go to record number -1 (or something like that) then place the data I found into that record?

Using Access 97 I need to find any time there is data in the ADJ field, then take that data, move back one record, and place it in the ADJ field in that record. Data will only appear in a table once or twice and always in the record after where it should be. Anyone know an easy way to do that?

Using Access 97 I created a query that works. Then I took the SQL version of it and pasted it on a button but when I click the button nothing happens. What am I missing? Here is the code I have on the button: Private Sub CmdRemove_City_of_Phx_from_Cost_Center_Field_Click() Dim STRSOURCE As...