Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bry12345

    CSV with Null Export Issue

    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...
  2. Bry12345

    CSV with Null Export Issue

    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...
  3. Bry12345

    CSV with Null Export Issue

    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...
  4. Bry12345

    Query: Calculate date/time plus five minutes

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

    Query: Calculate date/time plus five minutes

    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...
  6. Bry12345

    How to handle blank boxes on form

    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
  7. Bry12345

    Rebuilding a Groupwise 5.5 Server

    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
  8. Bry12345

    Rebuilding a Groupwise 5.5 Server

    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...
  9. Bry12345

    Auto populate form field

    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...
  10. Bry12345

    Auto populate form field

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

    Auto populate form field

    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
  12. Bry12345

    Auto populate form field

    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
  13. Bry12345

    running a hidden query

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

    Loading default data into a popup form

    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...
  15. Bry12345

    Exit and close a form while opening another

    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...
  16. Bry12345

    Putting Background Music

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

    Loading default data into a popup form

    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...
  18. Bry12345

    How to not open an empty form

    ...criteria. Based on that, you can decide the appropriate actions for when matching records exist and when none exist. - - - If DCount("*", "qryYourQry") > 0 Then 'Do whatever when you have at least one match Else 'Do...
  19. Bry12345

    Exit and close a form while opening another

    Can you post your code? - - - - Bryan
  20. Bry12345

    Only one person allowed in database at a time??

    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

Part and Inventory Search

Back
Top