Search results

Hi There, Hoping someone can help as I've got a bit stuck! I am dynamically constructing an SQL query within Access VBA to allow a user to define what columns they want to include in a query and then also define the criteria. My VBA then constructs the SQl code from what they have entered...

Hi, I have a form which loads containg a sub form based on a query. The query is definded in a previous form by the user who selects options from a list box. I've got the query defs VBA sorted and all works fine. However, the form that loads showing the sub form which displays the query...

Hi Everyone, I am trying to get a database working that was written by an old colleague of mine and worked perfectly well on Access 2000. I am now working on Access 2003 and part's of the database are no longer working, I presume because of the new version?? There seems to be a common point...

Can anyone help? I need to save a report to a PDF and am using the following code: Private Sub Label16_Click() DoCmd.OutputTo acOutputReport, "All Active Change Controls Report", acFormatPDF, ("Change Controls" & Format(Now(), "mmmyyyy") & ".pdf"), True End Sub I am getting an error saying...

Hi All, Please can someone help with this: I have found the following code: Option Explicit Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _ "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long Private Type OPENFILENAME lStructSize As Long hwndOwner As Long...

Help Please! I have had two instances in the last two days of database which have been running perfectly ok via Windows Scheduler for years, that have suddenly stopped opening. The database file itself is still visable in the network location, however if you try and open the database, Access...

Hi Guys, Does anyone know if there is a way to output a text file from Access to an FTP server which will be password protected? Thanks B

Hi All, here's the problem! I need a table created which has the same header names repeated across the top several times. i.e spcl_loc_line, spcl_note_value, spcl_note_line, spc_note_value etc etc. To do this all I could think of doing was having my base table with my header rows as actual...

:) Hi Guys, Could do with some help here, not sure how to go about this. I'm a beginner at VBA and this is a little out of my league!! Been seraching for a while but found nothing so far that could help me. I would like my database to conpact and repair once per month automatically...