Search results

That works. Thanks very much

Hi, The code below opens the PDF document - 2WLAPAS.pdf – from a folder on my desktop. Option Explicit Option Compare Database Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _ ByVal lpFile As String, ByVal...

Hi,My database generates forms with a unique number displayed as a barcode.The paper forms are completed by employees and then scanned into a folder on the network in .TIFF format.I have seen other databases that can somehow “pick up” files like this and update the forms status in the database...

Hi, The code below opens a PDF that I have specified in the code (Sales.pdf). How can I change the code so that I can select a document name from a list box and have the correct document open? The form containing the listbox is called frmDocumentDetails and the listbox is List1. CODE...

That works. Thanks very much. (I couldn't find the "Thumbs Up" to click it!)

Hi, I want to open the Calculator by clicking a command button (using the On Click event). I have tried the code below but can’t get it working. What do I need to change? Private Sub Command7_Click() Dim RetVal As Integer RetVal = Shell("C:\Windows\calc.exe", 1) End Sub Thanks very much Dave

That works now. Thanks very much pbaldy.

Thanks for that. I don't really understand this code so have just pasted it into my code. I still can't get it working. I have placed this code in the reports On No Data event code. Is this correct, or should it be in my code for the commandbox On Click event? Thanks very much Dave

Hi, The code below works to open a report (after some help from PBaldy). Private Sub CmdSubsystem_Click() If IsNull(TxtSubsystem.Value) Then MsgBox "You did not enter a Subsystem number", vbOKOnly + vbDefaultButton2 + vbCritical, "No Criteria Entered" Else DoCmd.OpenReport...

Thanks very much, PBaldy. That solved my problem.

Hi, I have a report (rptTESTInfoBySubsystem) based on a query. I want to be able to enter a Subsystem number (e.g. 4302-023-500) into a textbox (TxtSubsystem) on a form, and click on a command button (CmdSubsystem) on the same form to have the report opened and show only results for Subsystem...

Hi, I have a report that is fed by a parameter query. When a command button (Command23) is clicked a parameter box opens and the user enters a subsystem number. A report for that subsystem then opens. I want to open the report with VBA and show a message if the user has failed to enter a...

Hi, I have a problem with an If statement. If the value of Text7 is Null and the message is displayed I do not want the portion of code after End If to be processed. How do I change my If statement to achieve this? Thanks very much. Private Sub Command6_Click() If IsNull(Me.Text7.Value)...

Hi Forum, I have a criteria in a parameter query that asks the user to enter a Subsystem number (such as 4596-666-001). The source data for my database has Systems (e.g, 4596-666) and each system has several Subsystems associated with it (e.g, 4596-666-001, 4596-666-002, etc). The System and...

Hi Forum, I have a query that I use to populate a report. The query has a parameter box that opens and asks the user to enter a date. I would like to display this date in the Report heading. Is there any way that I can grab the value entered into the parameter query and display it on my...

Hi, I have a Form with a control button that opens a Table using VBA code. I have made quite a few similar databases before and usually when the Table opens it opens "above' or in front of the Form. This time the Table opens but behind the Form. I would like the Table to open and appear...

Hi Forum, I have done this before but have not used Access in a long time and can’t work it out (driving me crazy!) I want a List Box on a Form that takes its available drop-down values from tblDiscipline and puts the value selected into the Discipline Field of tblEquipment. The problem is...

Thanks pbaldy, I will take a look at this and see if i can work it out Dave

Hi, it appears my example table has not come out as a table. Sorry

Hi Forum, If I have a Form that is used to populate a Table can I make one field entry dependent upon another? For example, if I have a field for Discipline (with values such as Mechanical, Electrical, Piping) and another field for Equipment Type (with values such as Motor, Gearbox, etc) can...