Search results for query: *

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

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

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

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

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

Help, I would like to put appointments in Outlook Calendar and when i click on it, i would like to run an MS Access form like say a Work Order. Can this be done in Outlook?

First, i put an work order appointment on the Outlook Calendar; input the work order number and the name of the customer. I would like to click on said appointment and would like it to open an MS Access Form showing a Work Order Form for that certain customer and date/time. Does Outlook let you...

Hi, I made a query to UNION two tables with same structures. One is WorkOrderActive and WorkOrderDone. Both tables have INNER JOIN to a CustomerTable. So in both WorkOrderActive and WorkOrderDone tables, i only have the CustID field. In the WorkOrderForm, it shows all the CustomerTable...

Hi, This is easy for you guys. I know I've seen the VB code for this; but when you need it you cannot find it. Please give me code to check whether a form is open or not. Thanks, Jun M

Hi, I have a sort of a work order system where i have 2 tables: on-going work order table and completed work order. In a single form, can i make a search which will show all on-going work and completed work for a certain customer? This means that my form will sort of combine the 2 tables. Is...

Hi, I have a form named "WorkOrder". I have another form where i have an option group (1) choose to sort the WorkOrder form by WorkID and (2) by CustomerName. So i figured i have to write a code in the On Open Event of the WorkOrder form". If Option=1 then sort the WorkOrder Form by WorkID...

Hi, I have a form for a Work Order Table. It has a list box showing work order records, choose one and the form goes to that record. When i filter the form to let say State-"California"; i want the list box to also filter out and only show those with California as State. Right now, the form...

Hi, This will sound very new. Im working on a Work Order Form with customers info in it. On a button "Find map", I would like it to open the application 'MS Streets & Trips' and automatically insert my addressfield from the form to MS Streets & Trips's search box. So i dont have to type the...

Hi, Im working on a Work Order Form with a subform for Labor. Lets say its name is 'laborsubform' When i add a new Work Order record to the form; i want to autmatically add a new record to the laborsubform too. I tried to put a code to the form's AfterInsert Event but doesnt work. Please...

Hi, Please give me syntax on how to print a form but only for the current record. Otherwise, it prints all records. Thanks, Jun M

Hi, Im using MS Access 2000 working on a database in my laptop while im mobile. When i get home, i copy the .mdb file to my desktop 'cause im more comfortable using a desktop to continue working on the .mdb file. But i got this error and cannot open the file in the desktop: "The Microsoft Jet...

Hi, Am thinking of making life easy by just printing my Work Order Form. I can filter it to just print the current record shown. It prints everything except the 2 subforms in it namely: Parts & Labor. Is there a way to make these printable? I have 2 command buttons in the form too that i...