Search results

Gentlemen, To both of you I owe a great big THANK YOU! I now have several of the report generators work as I want them to, however; when I present this there'll be several more changes I am sure. Honestly, Bob, the date functioned as expected. Before the changes you suggested. If I wanted...

Text for Query/Form Well, I can't thank both of you enough...............The first suggestion fixed what I was trying to do and I'll add the rest with further testing. Please color me embarassed:o. Again THANKS! Nav4 (typo corrected)

Text for Query/Form Well, I can't thnak both of you enough...............The first suggestion fixed what I was trying to do and I'll add the rest with further testing. Please color me embarassed:o. Again THANKS! Nav4

OK, first, I am no VBA or DBA. I have used DBIII and SBDIV ......some and have used Access for some limited useage, nothing complicated. I am trying to input to a query from a text box. If the input is left blank the the date fields functions as expected and limit the records for the dates...

OK, I give,...Below is the code. When I add the last And, I get a error message on the query, indicating it doesn't like the last And. If I do not put it in,it shows the parameter query box with the Value from the drop down box. If you put the same value back in, it runs like it is supposed to...

Code Added Private Sub CmdGenRepSM_Click() On Error GoTo Err_CmdGenRepSM_Click Dim stDocName As String Dim stWhere As String Dim stDates As String Dim blnTrim As Boolean If Not IsNull(Me.CmbCl) Then stWhere = "[Crew Leader]=" & Me.CmbCl & " And "...

Bob, After several attempts............ I can almost get it working. It comes up with a dialog box, if I simply enter, it returns a blank report. If I add the info it comes back with another parameter entry. If I leave this balnk it agains returns a blank report. If I enter the name...

That looks exactly what I am wanting. I'll play with it and see if I can get it to work like I want it to and give you an update tomorrow. Again, THANKS! Nav4

Can this be done? I would like to genreate a query from a form. So when I want to run a monthly report for a month I can pick a mont or a date range and a criteria for the form such as crew meetings attended, paperwork in on time or up to seven different points of interest for a particular...

Supposed to work........... The way I intended for it to work is............ The User opens the database, there are approximately 10 vehicles per week that get a PM. The User has a list of these vehicles. She inputs the vehicle number - 12345 - the database is supposed to come back and giver...

Set Up I sat it up to pull info from a fairly static table and to write to a "active" table "SMMVehPM" where I can pull information for reports. The difference in the information is trouble pulling ffrom the "master" table on a consecutive basis. Ifn you pull up a vehicle, it does nothing. BUT...

Additional Info I've attached the info...the form, subform and data tables. The calendar won't function as I didn't include those.

Reply OK, I checked. It appears to be normal.............. Any other suggestions?

I am having trouble with sub-form pulling down related items....It worked once and I change from relating from one to another and it won't work. If I pull information form a combo box, it just sits ther. If I go from design view to form view it will work ONCE. The combo box works all of the...

I am trying to generate a Query by week always beginning on a Monday. I pick any date....and want all records in both printed version and chart version i,e, number of safety meetings attended vs number who should have attended for this week. I can enter data with todays date, well any day this...

Nope, nothing in it. Just a start.

I am basically trying to add the date at time of input to the table SMMMAttend. I can get it to display with a simple date() in the date box in the forms design mode, but it does not write to it. If I input by hand it works normally and all dates are there. Yes the code is fubarred. Nav4

Thanks Thanks, Again!

Zipped file Can't tell you how much zI appreciate this. Haven't used Access since it's infancy and not quite the same as dBase III or IV Nav4

I have been trying to do this from the Wizard and Event Handler, have not use the code for any of it. Maybe why I am having so much trouble?