Forms

error 2763
I have a main form and data entry form. There is datetimepicker on the data entry form. I got error 2763 DTpiccker returned error:Property is read only when database windows does not show for user version and user closes the main form when data entry form opened. I set the datetiem as today picker on at data e... 30 Jun 2008 10:39

Edit a pdf document
Is there any way to open and edit a pdf file using vba? If so, does any using this code need a full version of Adobe on their machine? Thanks in advance. ... 30 Jun 2008 15:49

close forms prior to previewing/printing
I have a criteria form from which I preview/print reports and need to close all open forms EXCEPT the criteria form and a main menu prior to previewing/printing. What I'd like to do is click the preview or print button which will close the forms prior to executing other commands. Is there a simple code to do thi... 30 Jun 2008 11:42

syntax error missing operator
I'm getting this error and it's regarding this: DoCmd.OpenReport "rptPKWeightCalculatorASSsFGs", acPreview, , _ "[PKWTID] = " & Me!PKWTID The problem is that values in [PKWTID] can contain non-alphanumeric characters, underscores, etc. such as: PKWT100050_6/12FLOZBTGLCLPLLAPAPER The underscore and th... 30 Jun 2008 10:39

front end and back end
I just learned that it is efficient that split mdb to front end and back end database. I just wonder that does it mean that front end and back end communicate with SQL string and result set to reduce network traffic? Does it mean that query should store on the backend, because it will be faster front end sends... 30 Jun 2008 12:44

Automating/ Verifying data entry in a form
I have a table shown below UserID FName LName Pw 1A FN1 LN1 FN1LN1 2A FN2 LN2 FN2LN2 3A FN3 LN3 FN3LN3 4A FN4 LN4 FN4LN4 I now have a form with 4 textboxes named txtUserID txtFName txtPW txtLName My Questions: 1. How would I set the controls so that when a user typed in his username... 2 Jul 2008 09:50

Print All/Selected
I have a form that list Invoices to be printed. On the form I have 2 buttons 'Print All' and 'Print Selected' with an option box to print either to window or printer: Private Sub CmdPrintAll_Click() Select Case Me.optPrint Case 1 DoCmd.OpenReport "rptInvoice_printQueue", acViewPreview, , , acWindowN... 30 Jun 2008 04:31

Compile error in query expression
This worked the last time I opened the database. reportDate: IIf(Len([last call time])<7,Date(),DateValue(Left([last call time],InStr([last call time]," ")))) It gives "compile error in query expression" now I have run all parts of it in an immediate window and they work. I can find no missing references. V... 30 Jun 2008 00:26

search form
I have made a form that searches for selected items in a table. When I run the search the only item it finds is the second one in the list. For instance, I'll put in the item id# in the search box, if it is not the second one in the list, it will erase the from. Does anyone have any idea what this could be? I'd... 29 Jun 2008 20:21

Open form based on query result
Hi Group, Winxppro, Access2000 I'm having a problem figuring out how to write my where clause. I have a query that returns job numbers based on entering all or part of a sales order number. The query is run from a command button on my "menu form". frmMainMenu. SELECT DISTINCT tblPackageData.JobNumber FROM ... 7 Jul 2008 20:44