Search results

no luck so far... i've looked under 'options' and 'startup'

acCmdCompactDatabase is available in '97 - however i am prompted by a window to choose the Db i want to compact ~~ i want this to happen automatically. I've tried using both of these. but the .runcommand doesn't support arguments. any suggestions out there? Dim db As Database Set db = CurrentDb...

pbaldy, I tried dropping the "set" but now i get an error saying i've canceled the previous operation. oh well, I'm going to go with the queries anyway... thanks again for your advice.

MSAccess '97 I have often wondered this question, compact a database automatically... is this possible for v97? My help file doesn't recognize acCmdCompactDatabase. And to add to sdawson, does it matter if the db is split? which end gets compacted?

Pat, i've found the immediate window for debugging. However, I do not know how to use it. I've tried a few combinations. :confused: 1) I put Print DMax; "[RevisionNumber]", _ "tbl_TitleBlockEngineeringChanges", _ "tabon = Forms!frm_tool!tabon)" in the module after the DMax code and typed the...

dynamic queries what exactly is a dynamic query? I thought simply writing out a SQL statement using code (as in the first part of my code) instead of a physical query meant dynamic? if not, what is what I did called? thanks again pbaldy! :)

pbaldy ~~~thanks for the reply so it's not considered "inexprienced" to do things using querys and not code? that's refreashing to know. I did have a question on this... I tried the following and got an error "Invalid use of property" which highlighted .RecordSource stDocName =...

hey there fellow texan.. yes, i have it defined as a long interger. you had me worried for a second, had to go ck it out. what a silly mistake that would be. i've been know to do far worse.

really, i've tried to search this one... I am trying to open a form2 based on the input from the user on form1. (Literally, the user inputs an upper and lower range to search for tool diameters that meet this criteria - i.e., show all tools between .25 and .3). I can get this all to work using...

Pat, Maybe I have my code in the wrong place. It's in the BeforeUpdate event of the subform. I tried the print feature that you recommended... I put that infront of the code that I already have BUT I got an 'Argument not optional' which highlighted the DMAX when I ran it. I also tried the...

andy_d I have had most difficulty with images in Access. Embedding is not the way to go. Access can increase the file size of your original image by 3X... If you can use an icon that links the picture to your db, that can work for you. I think using PDF will give you a greater flexibility with...

hmm, now i'm really confused. TAbOn is not a numeric field, it contains text and numbers, i.e. 11ABCD. I'm trying to get the rev number to increment. It seems like this should be so easy <frustration> Me.RevisionNumber = DMax("[RevisionNumber]", "tbl_TitleBlockEngineeringChanges", _ "tabon = '"...

Still new to this site and VBA, but found this post which handles a problem similar to mine http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52918&highlight=increment Here's the code for my application, but my output is zilch! Private Sub Form_BeforeUpdate(Cancel As...

Pat, I agree with the confusing part. I was only concerned that after I split the database and removed all the menu functions that the highlight and delete function would not work. But I just did a mini beta test and all is well...:) Thanks for your help.

I have looked through several posts but can't seem to find exactly what I am looking for. I have a subform in datasheet view and would like to erase just one of the records. I would like to put a command on click event on the main form that will erase this record when highlighted. The database...

by golly, i've got it. I put in a docmd open form and set the dataentry property = false before the If statement.

It is in a subform called sfrm_CToolInfo which in on the form frm_Tool. Actually my frm_ToolGeneralInformation is not open, so I moved the command to change the data entry property after the docmd.openform statement. The problem with this is, the property changes but the filter set in the...

Access provides a quick code builder using the toolbox's command button Private Sub yourcontrol_Click() On Error GoTo Err_yourcontrol_Click DoCmd.GoToRecord , , acNewRec Exit_yourcontrol_Click: Exit Sub Err_yourcontrol_Click: MsgBox Err.Description Resume...

I have the following code. My delimma occurs because the form i'm opening, frm_ToolGeneralInformation, is used in my database to add new records, hence, I have set the data entry property to yes. I'm wanting to use this same form to update information on the Tool deleted in the subform, and to...

i don't know how to do it in code :( sorry