Recent content by gaccess

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...

I remembered I had this filed away

I have a similar arrangement sort of ish So your control on your main form could be Combo20 (get into the habit of Naming things with relevant terms, it really helps) I have chosen "3" that is the PK no. in my db for this popup req form Private Sub Combo20_LostFocus() If Me.Combo20 = "" Or...

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...

OK Heres a copy of another post with 2 options I tried the 2nd one first must have done something wrong. looked at the first option to make the primary key the text entry and it was a five minute fix Thankyou all:) In a continuous form or datatsheet, the combo appears on each row but there...

Hi spikepl wow quick reply , Im just looking at something at the moment to do with superimposing a text box and having a Dlookup sounds odd but if it works skin your cat whichever way. Ill post more Thanks

I want the 2nd cbo to show the text value from col 3 I temporarily set the col widths to >0 to try to see what was happening No I didn't realise that until i read your reply (although it doesnt change the result on the form So when the cols are set .5;.5;3cm Choose 1st cbo - options...

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...

looking at this from another tack, in the form can I have a search to take me to a date. The right click filters to only that date and I have to clear filters to show all again and the navigation search is really clunky

mmm there is only to be one entry per control per day so the date is unique to that record set, also yes I think an autonumber as ID and if only I could have the date auto populate in sequence

well I could and have the Date as another control on my form but I want it to be consecutively populated with the date. Hell I cant expect staff to work out which date to put in. "Human intervention, the curse of computing"

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...

thankyou again last week I ordered Access VBA for dumbos nobody told me that the more you learned about this program the more you realise you don't know

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...

oops I got a bit carried away in the cut and paste dept, thought I was seeing double. Thanks for your help but it was a bit like pushing a blind man from behind into the freeway traffic-he might make the other side So I have tried DoCmd.OpenForm "frmIncident", acNormal, OpenArgs:="strDepot"...