Search results

  1. A

    Loop does not stop at recordset condition

    Hi! I am trying to use the following but it is still giving me the same error message (#3021) do until IsNull(rec("ccc")). I have also tried the IsEmpty(rec("ccc")) with the same results ie EOF error. ccc is declared as a TEXT field if that is of any help. Please let me know if there...
  2. A

    Loop does not stop at recordset condition

    I am trying to use this code when a form opens. Essentially what the code should do is to stop at the record when a certain field("ccc") has no data in it. The problem is that it does not stop at the first record with the above condition but goes on till the EOF and the gives me an error...
  3. A

    Code required for searching unlocked records in multi user situations.

    I need help with some Visual basic code for a multi user environment. There will be about 20 user updating data using a form linked to a table. (so effectively tha table will be getting updated). There will be pessimmistic locking used while they are working on the table updates through the...
  4. A

    Problem in editing records on a network

    I have question about editing data on networks. There is a table which has clients names and phone numbers and a field called "Contacted". The editing is done through forms. There will be different people editing the records. Now if two people (for example) are contacting a client and if...
  5. A

    Close open reports first when exiting MsAccess

    Thanks for all your help. What I am going to do for the time being is run your report closing VBA code on the event that the form closes. I will add in the code to delete the table within your code. This should be sufficient for the time being so that I can get the project on time. In the...
  6. A

    Close open reports first when exiting MsAccess

    I could not send the file because I dont have the program which can zip a file since it is not required for the work we do. But just one last question to clarify matters. When I program a macro to open reports there is a "Where" condition at the bottom. Is this the place to specify the filter...
  7. A

    Close open reports first when exiting MsAccess

    The report is based on qry2 as per your diagram. There are different query sequences for each report and there are about 11 initial reports. Now for Toronto and Montreal there are 11 reports each ( for 22 more so a total of 33). So effectively as per your query sequence I would pull three...
  8. A

    Close open reports first when exiting MsAccess

    The reports are are based on multiple queries. The sequence is something like the following: Table1->Query1->Query2->Report Now the problem that I was initially having was that the report does not work for the filtered data (but for all data even though it is filtered). So if I want the...
  9. A

    Close open reports first when exiting MsAccess

    I am working on this project which pulls up reports based on a table(say table1) which is created when a certain form is opened. The table is deleted when the form is closed.. The report buttons are on the form. Now if a report is open and the end user closes MsAccess without closing the...
  10. A

    Close open reports first when exiting MsAccess

    How do I use the above code as an event procedure? Like for example I need to activate this code when MsAccess is closed if a user clicks on the X button. Thanks.
  11. A

    Close open reports first when exiting MsAccess

    I ahve a situation where I need to close all open reports first when I exit MsAccess.exe. I should not have to specify which reports are to be closed (because all open reports have to be closed first. How could this be done if it is possible to do so? Thanks.
  12. A

    using an AAPEND query to transfer data

    Thank you for the help. It solves my purposes.
  13. A

    Using VBA to check whether a file in a folder in a certain drive exists.

    This works for me also! Thank you!:D
  14. A

    Using VBA to check whether a file in a folder in a certain drive exists.

    I have been trying this code today and it always returns as false even if the file exists. Also, do you know know what the following code is for? Thanks for the help. On Error Resume Next strfisfile = Len(Dir(stPath)) End Function
  15. A

    using an AAPEND query to transfer data

    I have a simple question for an APPEND query. I have two table (TABLE1 and TABLE2) both tables have the same field names and there is no primary key. I would like to append all data (for all the fields) from Table2 to Table1. How would I do this? Thanks.
  16. A

    Using VBA to check whether a file in a folder in a certain drive exists.

    I am using a batch file to automatically import a certain table which is originally in the TEXT format. The batch file invokes an ACCESS macro which does the actual TransferText procedure. There are time that the TEXT table may not exist in the required drive and folder. But the windows...
  17. A

    Need VBA code syntax to check if a TEXT file exists on a certain drive and folder.

    I would like to apologize for posting this on the REPORTS section in error. it should have been in the VBA section. Am reposting it in the VBA section.
  18. A

    Need VBA code syntax to check if a TEXT file exists on a certain drive and folder.

    I am using a batch file to automatically import a certain table which is originally in the TEXT format. The batch file invokes an ACCESS macro which does the actual TransferText procedure. There are time that the TEXT table may not exist in the required drive and folder. But the windows...
  19. A

    Would like to get rid of prompt for copying a table to an existing table

    The date is in a different field and the time is in a different field. The width is delimited. In the .txt file the time is in qoutes (ie "12:10:13 PM") Thanks.
  20. A

    Would like to get rid of prompt for copying a table to an existing table

    I am in the process of doing exactly the same thing as you have said. ie using the advanced TAB. Now there are certain fields which are time fields and are not converting to date/time. In the TEXT file they are like the following : 10:15:16 AM The date field is showing no errors and...
Back
Top Bottom