Search results

Any help with this is much appreciated. For each record with a "2nd" code on a specific date I am looking for another with a code <> "2nd" for that date. If there is none I need to delete the record with "2nd" code. Conversely, if there is a record <> "2nd" on a specific date without a...

Hi I have a form with 4 sets of 2 subforms. Both are linked to the main form. The first subform (Obectives) can only use data in the list of a combox. The second (Interventions) is also linked to the Main form but can also contain data other than in the list. The Interventions subform main...

Hi I have a continuous form subform set to dataentry. This works fine with the first parent record but when I navigate to a new record the subform shows all records linked to the parent. How do I keep the subform set to dataentry for all records? Help is appreciated. Thanks Alan

Good Day I have a form that has 4 sets of 2 comboboxes - the second based on the first - and 4 subforms each linked to the second cbo in each of the 4 sets. All subforms can grow and shrink and the detail is set to can grow. If I have more than a few values in the subforms and try to print...

Hi - I was tempted to just say "uncle I give up" for the topic title. Any help is much appreciated. Alan I have three tbls linked together - primary key in the clients tbl connected to tblITPlan with a fldlookupclient in that table and tblAction connected to the primary key in the TblItplan by...

Hi I know this may not be the right place but am hoping someone will give me the down and dirty about networking. I have built a single user msaccess application but want to make it into multiuser. If on a home network does that suffice or do I need some server software?? Is this a hassle to set...

Hi When connecting to a word file using odbc, the word message "opening this document will run ..sql" is hidden from the user. Is there a way to have the messagebox from word popup over access? So far the only way I have been able to view the message is to minimize access - I can do this with...

Hi - Access 03 I use the a macro with runcode with the following code to bring up the print dialog box. If the form detail is gray it changes it to white and then back to gray after printing. fldnote is the controlsource for Lebans rtf and for the heck of it i put the same controlsource in a...

Hi I have a command button that opens a help file with a helpcontextid. This works but there has to be another way. Any help is appreciated. Alan Me.helpfile = "c:\applicationfolder\help.chm" Me.HelpContextId = 108 SendKeys "{F1}"

Hi I open a form from another form. I want the name from the first form placed in a cbobox on the form opened. The cbo field is bound to a lookupnumber field. Any suggestions are appreciated. Alan

Hi I've been having problems with my db where the debugger isn't working. I think it has something to do with the linkage to the backend. I initially corrupted the db when trying to rename objects using naming conventions. I have tried the saveastext..... several times. I then unsplit it and it...

Hi - hope you can help I renamed all my tbls and qrys to convention. I don't think I compiled enough during this and the application froze when trying to close a form after working on the module- never to be the same. When reopening -the module I was working on was empty so I copied the code...

Hi I need to have and if then statement in a word merge document. It should look like this if {mergefield goal1}="" then {mergefield newgoal} end if In access there is a textbox declared. I am lost with this. Any help is much appreciated. Alan

Hi I want to reference a mergefield in a word document from msaccess03. Something like this except this doesn't work. Thanks any help is much appreciated. Alan Set objword = GetObject("C:\program files\addedforms\mbhp.doc") Me!test = objword.{mergefield "enddate"}

Hi. I hope you can help. I am using a module that allows me to open an mde and import a form into it - that is as long as there are only macros and no code behind it. I need to append the name of the form to a table. However, I need to reference the database since it has to be in another db...

Hi I'm about to start banging my head against the wall :eek:. Please help me figure out what's happening. I have an mde db that uses runtime. this is an msi installshield build. I have the accessrt and accessrtcab in the installdir with the mde and backend db and one self registering rtf.ocx...

Hi I am able to loop thru a table to find the name of a form that is loaded with the following code. dim nme as string nme = rst!name if currentproject.allforms(nme) then .. I then want to pass the nme value onto a form name to identify a rowsource forms!nme!name.rowsource =".... Access reads...

Hi I need to have functionality to import or export forms into an mde. I know that forms/reports w/o code and macros can be changed to functionality with an mde format but can't figure out how. Any thoughts or suggestions? Is this a security issue or code to change a constant? Alan