Search results

I have the same problem. I coded a DSNless connection that relink the ODBC tables each time the Db is opened by someone. Delays opening the main form a few seconds, but works like a charm actually.

If you are running a query to update the values, you just need to use OPENQUERY macro command. The query will have to pull the value for update from something else (like a form as an example).

Quite frankly, if it were me, I would place an autonumber field on each table and set that as your primary key. I would create a third table that; 1 has it own autonumber primary key (just for grins). 2 has a foreign key to the owners. 3 has a foreign key to the properties. 4 has a percentage...

Basically (if it is a date field) something like WeekDay(yourdate) = 1 If it was a string then something like this Instr(1,YouValueToCheck,"Sunday") The macro condition is sort of like the IIF without the then and else and the word IIF. Then means run the command, else means bypass this command.

Yes, but some pitfalls. Click your button: 1 - Run a query that gets a PRIMARY KEY for THAT record from the form, or stored somewhere, to use as a criteria to get the proper record, and appends it to Table-B. 2 - Release the record from your form (so it is not locked). 3 - Optional, verify the...

As long as Access is running, you can. You can set a timer event on a form and have it check something every so often. But you must remember, access is not an engine that is running all the time, so access has to be running for code to run.

To NOT return a record, it needs to be in your Criteria, not at a field level. WHERE ([JDNETP]<>0.59*[JDLIST]) as an example

maybe, but for a one time deal, don't think they will go for it. Any other ideas?

It needs to be in your criteria. need more information to assist further.

Is there a way to dump all the objects (forms, queries, reports) that contain each table? I.E. MainTable is used in; Query1 Query2 Form1 Form2 Report1 Report2 Report3 ETC.

SetWarnings depends if it is in a macro or event procedure

Have you supplied SQL security and have security on the SQL server to do this?

Well you need to move the values from one recordset to the recordset you are going to update. Not having done this, but don't see why it should not work, try: rst.Fields(nIndex).Value = rs.Fields(nIndex).Value Put your update after the loop.

We have had similar issues (although I would NOT consider 50MB an issue). What we have done is created an archive process that archives data to a SQL table (or in our case tables) and have an archive solution (separate access application called from the first one) that handles lookup and...

OK, So a Linked SQL table, has a varchar field that contains a URL. In my access app. I want them to select (via a description) the proper row, and when a button is clicked, run that URL (browser I guess). it is a SQL Report the URL is pointing to if that matters for any reason. So how does one...

It sounds like it is totally SQL permissions. Of course Access is passing the permissions, so you should see what access is using to connect to the SQL server with.

I know I can do it from Access, but I want to actually run the SQL report. Can a hypertext field allow that? I don't need the report IN access, I just want to run it.

Are they all date type columns? Typically with oracle, verifying your datatypes is first concern.

Can I run a SQL Report from Access?

Did you verify the permissions on each object when you swapped out the groups? Are the groups part of a ROLE you did not add them to?