Search results for query: *

Problem solved. AlexCuse put me on the right track. I didn't exactly use his solution, as I encountered an IIF syntax issue that I couldn't resolve quickly. (Another one of those 'emergency' projects!) I forced the " " in the export by preceeding it with action queries: - - - Dim strSQL As...

Thanks. I'm actually exporting through a query, so this should work. However, I getting an 'operator missing' error in the SQL statement. From a test database, checking for nulls in field 'three': SELECT tblMain.one, tblMain.two, tblMain.three: IIF(three is null,"""",three) FROM tblMain...

I am trying to export a CSV file with data from a table. The purpose of this export is to produce a file in a format for uploading to a mainframe. Scattered throughout the table are fields whose values are NULL. The problem that I am having is that Access only delimits NULL fields in the .csv...

Pefect! Thank you. The '5' is obviously the five minutes. The '1440', I take it, is the number of minutes in the day? - - - - Bryan

I have an application with several tables. Each table has a date/time field. I need to identify all rows in Tables B, C and D whose date/time fields are within 5 minutes of any date/time field in Table A's records. My thought was to start with a query containing a calculated field using the...

If I understand you properly, when you open the form, your bound controls are populated with data from an existing record, which is not what you want. Open the form's properties, and set the 'Data Entry' property to yes. When the form is opened, the bound fields will be blank. - - - - Bryan

It's a pretty small firm, so I had him recreate it on the new build. Because it was rebuilt from memory, it probably is not identical to the original. - - - - Bryan

I am about to try to help someone rebuild a Groupwise 5.5 Server that was running on a Novell 4x server. The problem is that the server was stolen, and the only backup available is a full logical copy of the single volume on the server. I have a clean install of 5.5 running. I'm just not sure...

Ok, so if I understand you right, you want to open the new form and pick up the 'call number' field (which is not the foreign key) from the 'call details' subform. Let me just say at this point that I'm not sure you are going about this properly, design wise . .but I don't know enough about...

Got it . . 'call form' and 'call details' are linked (the parent/child relationship) by the 'call number' field, right? - - - - Bryan

Ok . . I'm a little confused about what you're trying to do. What exactly do you want to happen when you open the New Customer form. i.e. what do you want linked??? - - - - Bryan

Too many parameters here, I think: Me![call number] = Forms![call form]![call details]![call number] What is the name of the form you are opening the new form from? Either 'call form' or 'call details' should not be in this line. - - - - Bryan

Not sure what you mean by the hidden mode. Can you be more specific about what you are trying to accomplish? - - - - Bryan

This is how I would do it. I've done this in a working app, and when there is no record on the 'many' side (ShipTo, in your case), it will open a blank form with only the linked field filled in. I set the link criteria as a variable (string), which helps me avoid syntax errors in the...

GSFMike, I see no reason Jim Hare's suggestion DoCmd.Close acForm, "frm_getPO" shouldn't work. To test for the possibility of corruption, I think I would design a simple test form with the same button and see if that one closes. While the test form doesn't mirror the form you are...

Jim, That gives new meaning to "behind the form" . . - - - - Bryan

The quick way would be to use the command button wizard to open the form based upon a value in the current form . i.e. the account number field. That should open the new form with the account number matched and whatever data in the shipto table record in the new form. If you want to post the...

You need to test for the presence of records in your query before you open your form, then use if logic to open a message box if there are none. This technique runs the query twice, once for the test and once for the recordset, but that should not be an issue except for very large db's. 1 -...

Can you post your code? - - - - Bryan

What server OS? What are the user's permissions for the files in the shared directory and for the directory itself? What message is the user getting when he/she is unable to open? - - - - Bryan