Search results

i have created a database using A'97. it's a split database with the be on a SQL server - used in a multi user environment. i'm set as the database owner on the server. however i have created a user group on the server that allows editing (create/delete/change records). i did two tests today...

i've got a crazy question.. or at least i think so. i'm helping a fellow worker with his DB. he has built a query with about a dozen columns of formulas. there's no table - no query... just the formulas. (and they're nasty nested iifs at that) i'm pretty sure he's going in the wrong direction...

Any help with this would be appreciated:) Here's a bit of code i got from this site (ref this thread: ) which hides columns on a subform when there are no values present for a particular filter on the main form. well, all was fine and dandy until i realized IF there happens to be a a value in...

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...

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...

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...

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 have a form with several subforms. In one of the subforms, the data is a result from a query (a select query built from two tables). This resulting query has many columns (more than 20 and growing by the day). Some of which don't always contain data for a recordset. On the main form as I...