Search results

Hello I have a form which has a listbox containing my tables. From that, I can successfully select a table and click on a button. There is a sub-form that has a recordsource that is set to the selected table. I am able to dynamically change the captions to the correct field names for the...

I have a facility whereby I import data from Excel spreadsheets into Access using some VBA code. The users have the ability to add new worksheets to their files (seldom used in practice) and I add these new names to my master list, together with some other attributes, and all sheets are...

Can anyone help with this? It will sound weird to you and you probably will think I'm pulling your leg but it is all true! I look after an Access 2000 Database. There is an existing report to which I added two new columns - one shows the results of a text box (where the values are H or S or...

I've been toiling with the issue of WHERE clauses on the "Right" side of Left Joins. I'm aware that you need to use JOIN ON......AND.... rather than JOIN ON....WHERE.... if the WHERE relates to the Right Hand table. I've even got an example in my DB where the above works, but now am struggling...

I have a combo box in a form which allows users to select a Client Group. One of the choices in the combo box is ALL. I have some code in a STEP1 query that says SELECT IIf(Forms![Date Picker].[Client Group]="ALL","'SEDP' Or 'LD' Or 'MH'",Forms![Date Picker].[Client Group]) AS Expr1 FROM...

Hi I need help writing a bit of VBA code as I'm not really too familiar with it all. I created the following to import a spreadsheet according to the values on a form and it works OK Private Sub Command12_Click() Dim InputDir, ImportFile, ImportExtension As String InputDir = Forms![Input...