Search results

A few ways to manage this... 1. Change your shortcut to a short script with a simple conditional check if MS access is already open. 2. A new table that creates a simple binary check that is flipped on when someone logs on and off when someone logs off. On logging in, the application first...

There's no getting around the 2GB limit. Try moving the tables into separate databases with table links controlling them to your primary database - which will contain the mergedTable.

I don't see an On Click event for Right Click - how do you capture it? Is there code which could function based on the form window instead of individual components inside the form? What about application window, instead of inside a form at all?

I'm actually looking for info on mouse interactions via VBA, then tying that to a form. You've given me events that are triggered off of objects - I'd like to trigger the event directly off the mouse click. Let's alter the request slightly -- I would like to update a txtbox with a simple...

I would like to update a txtbox with a simple int count of the number of times a mouse is left-clicked while on an active form. How do I do this?

I'm not sure what the form_click event (on click) does. Could someone provide a quick simple example?

You've a few things going on here... This is standard data normalization. This is good so far. To consolidate, simply create a pivot table of the excel table. See above. Standard excel pivot table will consolidate name, ID, e-mail, room, building then you'd have 3 listings for the 3...

pseudocode: if DCount("[FieldName", "TableName", "[FieldName] Like '*" & [inputbox] & "*'") > 0 ' the item exists then myarray(0) = recordset items. ' if you can't use SQL here to establish your recordset, you need to iterate by loop through your entire table to locate your matching values...

Can't migrate data like this. This results in bad joins to the rest of the tables if they're linked by AutoID Primary Keys. Again -- this assumes that the data integrity has been violated when the duplicate database was used in parallel with the existing database. If you review the data and...

It appears that you may be using autonumbers for your unique ID fields. Be sure you DO NOT use these when merging data -- the two databases were updated simultaneously, unique data may very well have overlapping autoID's. If this is the case -- You will need to create a new unique index...

If I'm not mistaken - adding indexes improves data communication speeds, but increases file size. Adding indexes to all fields for a multimillion row data file may well blow up an access database (max file size ~2GB). Keep an eye on your file size when you start adding indexes.

I think the screen flash is going to be much easier to resolve than OP question. There's several .screenupdate = false / true switches (syntax?) you could use and several other posts I've seen addressing screen flicker.

As far as I know, your current process is the most effective. If you have control over the process which submits data inbound to the table, you could add an event to every send to create a listbox refresh flag. Alternatively, you could keep an open connection to your table. I can't imagine...

Alternatively, you can run a quick VBA script-loop checking currentdb.tabledefs. Pseudocode: chktbl = table to check chkfld = field in chktbl to check For each table for each field in table does field = chktbl.chkfld - do stuff next next

Edit: Isskint beat me to the punch :) -- I've added details to his summary. The "proper" way to do this is as follows: 3 tables: Table 1: tblPrefix P_ID / Prefx 1 / Mr. 2 / Mrs. 3 / Dr. etc. Table 2: myNames N_ID / Name 1 / John Smith 2 / Betty Sue 3 / Joe Bob etc. Table 3...

Use vba to loop through all criteria, creating a string, then set title = string.

No. Your data must be sorted by some column. Typically it's the Primary Key AutoNumber field. Text will be alphabetized. Add a new column, call it sort order and number each item how you want it sorted.

The answer is...it depends. Are your users restricted to using a form front-end or do they have full access to the database tables (data)? In the first case - you can change the form on_open to lock appropriately, depending on which switchboard option is selected. In the second case -- it...

A version controlled front-end is installed on all clients.

holds employee info. tblContractors eTime User ID (PK) First Name Last Name Location Years of experience Area of experience General comment employee-skill join: links many employee to many skills! (employee can have multiple skills) tblSkills eTime User ID (PK) SkillsID (PK) Skill levelSubLvl...