Search results

Do all three of those fields exist on your form?

Is the file called "MyUsernameStudyPlan.doc" or do you want the username to be the folder?

Create a function that checks all three fields and call it on the before update event of each of Product_ID, Description and Colour. This should work, just not sure about how the Cancelling of the event will affect the recordset movements. Regards, Pete. Function CHECK_PRODUCT() As Boolean...

You can do it using VBA. Psuedo code would be: 1. Gather list of tables you want to export (if not all). 2. Create an Excel Workbook object. ----- 3. Get the name of the first/next table you want to export. 4. Create a recordset based on that table. 5. Create an Excel Worksheet object...

In other words, the line: GetFileNames Should be saying something like: GetFileName "C:\My_Folder_Where_The_Files_Are" Pete.

Yeah, I've tried all sorts of configurations with the page size etc. I've even opened PowerPoint, inserted the PDF object into that (it comes through at the correct size) and then copied that object into the report and it STILL shrinks. There must be a 'maximum object size' or something which...

Take the error handling off so you can see where the error is occuring. My guess is the error is occurring on the following lines: Select Case Me.Cl_Type Case "Auto" strFrmOpt = "Auto_Claim_frm" And strIDr = "Auto_adjID" Case "GL" strFrmOpt = "General_Liability_Claim_frm" And strIDr =...

I think you are pretty close. dim frm as form Dim frmName as String Set frm = CreateForm() frmName = "MyForm" frm.Name = frmName DoCmd.Save acForm, frmName DoCmd.Restore I'm just guessing there but it should be fine? Regards, Pete

Give this a whirl - you can call it from anywhere. e.g. files = Count_Files("C:\MyFolder") Regards, Pete.

You could put a password on the backend of the database ?

Kill the Dim t1 as TextBox line Pass in t1 as a string rather than a textbox e.g. Call Progression("Start Wash-up", "t1", c_Blue, BarTime) Then, in your function, change it to expect a string rather than a textbox e.g. Static Function Progression(Task As String, Interval As String, Color As...

Hello all, I'm running into a problem when viewing a PDF in a report. The report is an A3 page oriented landscape. The PDF (which is a technical drawing) is 38.85cm by 9.65cm. However, when I insert it as an object, it only comes through at 29cm wide, and when I resize it, the image quality...