Search results

nevermind CurrentDb.TableDefs(sTableName).Indexes(iCtr).Fields where CurrentDb.TableDefs(sTableName).Indexes(iCtr).Primary = True

I need to figure out how to ID the Primary Key in an existing TableDef through code. Anyone have any Idea's?

You should change your Record Locking from "No Locks" to "Edited Record" in a shared environment. But more than changing the default mode, you will have to go back into every form and change it cuz, changing the default only works going forward. Also have you distributed the front end to each...

use a dlookup method to count the number of records in your query, if the record count is 0 then don't open the form. Search this forum and Access Help files for info on Dlookup.

If you think it may solve your problem then go ahead and try, don't let us stop you.

If I followed your message right, you should be able to do what you want but I can't envision where to start, can you export the four forms and some related data to another mdb and zip it up and upload it?

Look into how you have your Relationships configued, you may have "Enforce Referential Integrity" enabled and if your subtables don't have related records, you get an error.

The text box in the Details section on a Continuous form will repeat/copy down for each record, thus copying all of it properties, so when you change the input mask of the text box it will apply it all down the page for every single record. Now, if you are using Access 2000 or later you can...

your probably better off at the following forum: http://www.vbdesign.net/index.php it deals a gread deal with AutoCadd, GIS, ESRI, MapInfo, MapMarker, MapBasic, and quite a bit about Importing/Exporting GIS and design data in and out of Access. Look for a user named CornBread, he's great.

probably not but you can probably solve this simply enough. Start by adding a new table to your access database with two fields in it, one being a unique id field that you populate with a "1" and the second being the field that you insert/store the value that you aquire from you Excel input box...

Since your opening a 97 mdb in 2002 there could be any number of problems, you need to install Access 97 and open it with that to see if there is any real problems, other than version differences. goto MSDN and look up changes between 97 and 2000. If you convert the 97 to 2000 or 2002 you will...

msgbox "The project number is " & me.Text1, vbokonly,"Message Title"

In design mode, set the second forms POPUP property to yes/true and it will always be ontop even though you've gone back and given the main form the focus.

You need to look into record locking and look up multiple users in this forum as well as in Access's help files. If your process is working with lots of data you may need to consider splitting the database into a front-end and back-end.

It sounds like you have dual criteria for executing what you want to do without an example of your code it's hard to offer advice. What trigger method are you using for executing the function. Can you upload a copy of the form/code and related tables that your working with?

you may also try replacing Forms![frmFilter]![txtMaximumPrice] with Forms![frmFilter].txtMaximumPrice since your refering to a control and not a memory reference.

Sorry, for the delay, just enjoying the weekend. Hmm... Not sure what the problem would be, can you export the two forms and related table to another MDB and upload it so I may have a look?

you need to move/copy your code to the target forms OnOpen or OnLoad events and then set the forms RecordSource property equal to the SQL statment and you should be golden Private Sub cmdFilter_Click() Dim stDocName As String Dim stLinkCriteria As String Dim Result As Integer Dim...

you need to dig into your sql server documentation and write a DTS package or store proc that does all of this for you or a combo of both, only you can figure out which is best for your process, and either can be triggered from an ASP page.

you can use the NZ function to trap for Dlookup returning null string = Nz(dlookup(),"") then check to see if the returned value is "" and use an inputbox to have the user enter the neccessary value.