Search results

thanks pat. i've read one of your posts where you describe this method of placing a timestamp table in the FE and BE and notifying the user when an update is necessary. it looks like i've got a lot more studying to do before i attempt such an application, but thank you again for all of your...

hi pat. thanks for all the information. as always your responses are very helpful. i've read several of your posts where you describe using Access as a front end to more powerful applications like Oracle. i think this is probably the way for me to go, but i'm still confused about how i...

thanks for the responses pat and llkhoutx. they were very helpful. i understand that VBA comes in many different flavors (Access, Excel, PowerPoint, Outlook,...etc) and syntax will vary based on the applications object hiearchy and application functions. does anyone have any opinion about the...

i know similar questions like this have been asked numerous times and i apoligize if this seems repetitive. i've read through the other posts but i'm still looking for an answer. he goes: 1. VB has come up at work lately and was wondering just how different VB is from VBA. folks at my...

thanks for all the help autoeng, john, and vassago.

aargh! my link still doesn't work. anyway for folks interested in this thread the title of the thread is "more info on database splitting"

thanks again autoeng. http://www.accessprogrammers.co.uk/...ghlight=linking not sure if this link will work but i found a great thread on my question with responses from autoeng and pat.

[URL http://www.accessprogrammers.co.uk/forums/showthread.php?s=&threadid=45545&highlight=linking[/URL] not sure if this link will work but i found a great thread on my question with responses from autoeng and pat.

thanks autoeng and john for your replies. they were very helpful.

hi john, thanks for the reply. this worked out great for choosing a different reference path using the windows dialog box, but i was wondering if there was a way for me to type the reference path. the IT group has done something a little funny. when they mapped the drives on the individual...

hi folks, i've recently placed a split dbase on a server with the back end on a shared drive and the front end on individual workstations. i've read setting up a multi-user environment this way makes the dbase run faster (jet runs on each workstation) and reduces the network traffic. here's...

hi nero, thanks for the response. someone told me i needed to check the 2.5 library to use the ADODB object. that's why i have it checked. is that wrong? what are the proper reference libraries i need for ADO code? many thanks again

hi everyone, i was trying to write some code with ADO and found out i needed to install the Microsoft ActiveX Data Objects 2.6 Library, but when i try to install it i get the following message: "Name conflicts with existing module, project, or object library" i read the help file associated...

if i'm understanding correctly it sounds like you might want a form based on an AutoLookup Query, which is similar to what FoFa was describing. this is a one-to-many relationship. you can make the relationship at the table level using a lookup field (one side to the many side) or create it on...

thanks wizcow. that worked perfectly. although i didn't include any error handling because i'm still pretty green when it comes to VBA. do you have any suggestions on recommended error handling associated with conditional formatting? thanks again

hi folks, i have a table with numeric data validation rules for a number of fields. this application is used as a log sheet to store monitoring values for measured parameters. the data valdiation rules i placed in the fields should apply 99% of the time, but there are some instances when one...

hi everyone, i'm working with an Access 97 application and would like to use conditional formatting for a few controls (text boxes) in my form based on a selection from a combo box on the same form. i know how to do this in XP using the conditional formatting property, but i'm totally lost in...

thanks travis. that worked perfectly.

hi all, i have a form in my application that i would like to have access automatically "gray-out" certain controls when the user makes a selection from a combo box on my form. basically i'd like to link the BackColor property for 15 controls (text boxes) to the combo box selection, but still...

i decided to go with default values (Null) and added a little label to identify to the user why those fields in question were blank for a particular shift. for these fields, i'm not interested in performing any calculations on them, but its good to know that aggregate SQL functions omit Null...