Search results

I have Access 2007 on notebook on Windows 7. 2010 on PC with XP w sp3 and runtime on another PC (xp) I want to develop some Access 2003 and have run out of hardware I have looked at the various problems here. Is it possible to use an external hard drive I have a XP os spare and a MS Office...

This must be simple "OR" I am The following code I am trying to disable or lock a control depending on the value of a combo box This works fine with one value BUT I want to lock Control4 with values 3 or 4 I have had the lines as If Me.SupplyToFK = "3" OR "4" Then If Me.Combo1 = "3" OR...

Solved :) Thanks All It feels like Ive trawled 10000 posts on this and tried almost as many attempts. Could somebody please look at this as Im bewildered. Not the normal problem. I have this set up just the way I want bar my 2nd combo after choosing the item from dropdown after update the...

I've been trawling all morning and have found not much. Some say yes some say no. So I have tried to copy code I have found. I want to have the Date increase by one on each new recordset. Kind of like a diary really. Except on current brings up error "method or datamember not found on the 3rd...

this might seem silly as a demo I only want a report opened to the same ID every time currently I have been playing with and trying to find anything (with record no 1001) Private Sub btnDemo1_Click() DoCmd.OpenReport "rptIncident", acViewPreview, , "ID = " & Me!ID End Sub of course this...

after abandoning hope for a day I have seached and found this code on databasedev.co.uk/login OK it works fine but I still want to filter form to show only the combo box/strDepot field selected. So I need to add something to the end of the DoCmd.Open Form Lines but i've tried a few things with...

Ive started a new thread after GinaWhipp kindly helped on the last one I have now been reading forums and trying things for three hours and getting nowhere. I have decided separate logins was a bit clunky. I have the "open with form" as a LogIn - Admin and different areas to log in with...

I have a switch board to allow login for a few users plus admin user - screenshot attached. I had the admin log in working or so I thought (well I was pleased with my first bit of VBA that worked then oh dissapointment when I found that no entry or blank would allow the main form to open my...

I am writing instructions for a DB (in MS Word) and although I have screenshots copied OK I want to just copy the buttons I have used. eg next record, last record, filter etc Any clues anyone

Hi I'm wanting to open a report to Print out just the information from the Current Record in Form View. I have a Command Button to a Macro The action is Open Report the Report Name is Purchase Order the Where Condition is [Order Number]=[Forms]![Purchase Order]![Order Number] Oh yes and Order...

I have a relatively simple DB that I need to date filter in a couple of reports. I need to filter all, before a date, two months ahead. Currently in the report I right click date, choose date filters, select pop-up calendar, select the date I want and of course that works. Is there a more...