Recent content by DeoM

Hi, Is there a way to programmatically convert a table to a text file? Please help.

Thanks AceMan, They are identical tables.

Help, Please tell me whats wrong with my SQL syntax; am getting a data mismatch error. POCreation is a blank table where I want to append data from POparts for only a certain PO number POnumber is Long Integer strPOnumber is a variable where i input the POnumber i want to append. DoCmd.RunSQL...

Hi, I have MAINform with CUSTOMERsubform. When I click on any record on the CUSTOMERsubform, it opens CUSTOMERDETAILsubform which should show the correct record based on CUSTID field of the CUSTOMERsubform. At first, it doesnt show the correct record but when i did a Me!Refresh, it did it...

Hi, I have a WORKORDERform with a PARTsubform. I want to click on a record in the PARTsubform which will open the PARTINFOform but will show only the particular record based on the PartID of the PARTsubform. Here's my code: Dim stDocName As String Dim stLinkCriteria As String stDocName =...

Thanks for the response Ascentient. But no, cmdApplyFilter is enabled; tried to enable it again on the on-click event of the cmdFilterByForm but it still disables automatically when i click cmdFilterByForm. Actually, all buttons and labels are automatically disabled whenever i click or activate...

Hi, I posted a similar question before but i got no right answers. Here's my problem. I made a form and a command button on it that activates "FilterByForm". I made another button on the form that activates "ApplyFilter". But when i actually click on the "FilterByForm" button, the...

Thanks PH, i should have thought of checking it in the laptop. I'll post what happens.

Hi, I am developing an Access Program in my PC with an XP OS and an Access 2000 version. I transfer it to a portable harddisk and copy it to a laptop running XP and Access 2000 too. Been doing it for several days already. But today, i got an "Object Library not found error". Any idea how to...

Hi, I created a button on the button to "ApplyFilter" of hatever field i chose data in it. The problem is when i click on the button i created which runs "FilterByForm", the "ApplyFilter" button is automatically disabled. How can i make this button stay enabled?

Hi, I noticed that when i do a FilterByForm, all buttons and boxes on the form are deactivated except the boxes "fields" where i can choose to use as filter. Is there a way that i can create a button on the form which i can click to "apply filter" instead of using the regular Menu.

Thanks Man, Nope, you syntax produced JOIN error. But I already figured out the correct way. I made a UNION query of ActiveWorkTable and FinishedWorkTable; named it AllWorkQuery. I made a form using AllWorkQuery and INNER JOINed CustomerTable to it using the Query Builder (no SQL specific...

Hi, In my WorkOrder database, I have 2 tables to UNION (ActiveWorkTable & FinishedWorkTable); both have identical structures. However, each has an INNER JOIN to CustomerTable on "CustID" field. My SQL is as follows: SELECT * FROM [ActiveWorkTable] INNER JOIN [CustomerTable] ON...

Hi Geoff, Im getting an error if I UNION the 2 tables first then apply INNER JOIN.

Thanks Geoff, I will try that. Access sure makes life worth living; the more you learn the more problems you have. But i like it; very challenging.