Search results

Declaring variables KSgirl: Just an FYI, but you may already know this. Take care in the way you have declared your variables here (you may have just short-cutted in pseudo-code, if that is the case I aplogise) Dim stDocName1, stDocName2, stDocName3 As String As it stands here, only...

Greetings from sunny Mississauga: I am sure there is a way to pull a variable or something in, but with my minimalist skills I never found out how. I got around the problem by creating a v. small table with just one field in it - the year number, and then dropped that into all queries which...

Ouchies. Desparate Solution 101 : did you try creating a blank database and importing all the objects from the corrupted database to see if that works? HTH

Jedi Drop down the fields you need into your query grid, including [Rent Due Date]. As the criteria for [Rent Due Date] just enter =Date(), this will return all the records for which the Due Date matches today's date. If you wanted a 'futures' report to look at, say, rents due in the next...

Hi : Thanks for that tip. Get a type mismatch error and I think I know why. The activecontrol is actually being taken as the command button I just clicked and not the list box. Trying to figure out now how to stop that or make sure that just the listbox is the active object. Any ideas?

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 : That message means that the two fields you are using as your join are of different data types. Meaning, one may be of a text type and one may be of a number type. Go to the design of the tables and double check it. HTH

Thanks Rich. Thought I was doing something totally dumb that was staring me right in the face, but it would appear not (phew - sigh of relief). Of a-fixing I go.

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

This is where your Forms and SubForms come into into. The Form (MainForm) would contain your "header" information - i.e. stuff that is common to all records, in this case User ID. The SubForm contains all the details pertaining to that user - applications and functions. HTH

Thanks Travis. Guess I'll have to eek back to the drawing board and figure out a fix (oh the joy, the joy). Donna

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

You know what ALL of my code is being ignored. Stupidly I did not realise that my error message line was the same as my msgbox. So now when I just ask for the error message to read "Error", that is the message I see. What am I doing wrong?? Help! TIA. Private Sub...

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