Search results

Hi All. I have a form which has a couple of multi-select list boxes. With the help of someone who knows far more than me, I was able to get the following code to work. What I am trying to do now is to use the Screen.Active object command to be able to distinguish from which list box the user...

Hi There : Um ... I know something is wrong in my design here but can't figure out how to fix it. I have my main form and my sub form, based on tblHeader and tblDetail respectively. For some reason, it is quite possible for a user to enter the header information on frmHeader and NOT enter a...

Hi All - having some problems wrapping my head around this and am stumbling dramatically. Can anyone help shed some light on what I should be doing and how I can improve it perhaps. I have a Main Form with Header information, and a Sub Form with detail information. I want to ensure that all...

Hello there! I've searched the forum for help on this but can't seem to find what I need. I know I can run batch files from Access but I seem to be hitting a brick wall. Maybe it's because I a bit fick or maybe because it's Friday but I'm just completely stuck. I have the basic syntax down OK...

Any chance either one of you could elaborate on this topic a bit more? This sounds like exactly what I need to do: I have code for ONE QUERY that loops through a list of sales reps and applies each name in turn as the criteria and exports the report under that person's name. I've been trying to...

Hi There, I need to do a check in my database to make sure a duplicate value does not exist and force the user back to that field to re-enter if it does. I have a mainform and a subform and this is my code: Private Sub PROJNUM_BeforeUpdate(Cancel As Integer) If (DLookup("[ProjNum]"...

Greetings : I'm a first time user of this board. Long time user of Access trying to improve my applications by grappling with VBA. I have a report which needs to be distributed to about 50 sales reps on a monthly basis - BUT I want each rep to only see their own data. Currently I have it set...