Search results

If the database is on a server then just get admin permissions on that server and boot them off it. remove the db for repair!!

hootie318 this is possible with at least two methods that I know. Quick and simple would be create the 12 months with check boxes and 1 year combo. then each time the form loads populate either set the check box to true or false if there is an entry in the table holding the info. u can use...

zip up the db and post it here and it will be looked at

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46948&highlight=alphabet+buttons

put them on a server!!!

What I would like to do is either use a listbox off a switchboard to select the AccountRep or at a minimum, be prompted to enter that into a prompt box. A) Create a combo or list box and then just refer to the selection from the query. But if u wish to return records for multiple AccountReps...

put two text boxes on a form and enter the two dates then refer to them on the report.

check out the attached:

SYMPTOMS If a table has more than 16,384 rows, and you click the Office Links button, and then Analyze It with MS Excel, you may receive the following error: There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access. This happens as well...

if i was u i would draw the report look and attach it here along with the db and you will probably get some help/ideas.

u can catch the error number also: if error=12345 then msg"blah" end if exit sub

Need a little bit more info on what records you wish to save and print. Post the db if u wish?

Assuming DateDiff("d", Now, TheDate) Private Sub Form_Timer() Dim ETIME as Integer Set ETIME = DateDiff("n", [TIME_OPEN], Now()) If ETIME > 15 And ETIME < 30 Then DoCmd.OpenForm "KYLE" ElseIf ETIME > 29 Then DoCmd.Close "KYLE" IT IS GETTING STUCK HERE! DoCmd.OpenQuery "qryDeleteInfo"...

or look here for a data model to get u started: http://www.databaseanswers.com/data_models/index.htm

You need a BA/DBA and some budget!!

Steve, Never come across a request to put query data into a text box? Why don't you just build a main or sub form on that query??

if u have one conbo box for two fields then y cant u just have two combo's, on for each field. Basically there would not be much difference in width and the user can enter data into the combo they want!

post the db & give a better report requirement

In the query that creates the report you must have somekind of unique ID . Therefore in the query you can either put the following in the Unique Fields criteria [Enter Unique ID] and u will be prompted for the Unique ID. or in the criteria of the Unique ID reference the form such as...

u can use a case and update recordset in vba or you can use an update query such as iif(left[SS],-2)=00) expiration date of license = "Janurary" Attach the db if u are unsure,