Search results

You're already referencing the control, why do you need: Forms!feature_form!Screen.ActiveControl.Name when you could use... control.name DoCmd.RunSQL "INSERT INTO tbl_FEAT_STRAT (feature_primary_ID, stratum_ID) VALUES (Forms!feature_form!ctl_prime_ID, " & control.name & ")"

In a form - How do I layer an object on top of a listbox? :banghead:

Make a backup. Move Backend to your desktop. Decrypt backend. Repair / Compact. Create a new database (blank frontend). Test A. linking tables Add table links to the front end. Do you have any problems? Test B. encrypted linked tables Delete all linked tables from the front end. Close the...

A few things: tbl _b and _c could probably be normalized down to a single table and much fewer fields. Field "Domain" through Field "Kronos" should probably be 2 fields: (Descriptor / Value) Domain Security Group appears to be sub-lvled in your relationship. How did you do this and what does...

What is the typical process for standardizing a time? The process as I see it: ... To convert all times to a consistent timezone (GMT for example), I need to A) determine user's timezone, B) determine difference between user timezone and GMT, C) manually add/subtract time difference? While...

edit: late and his picture says the same thing. The database should be open in exclusive mode. - The instructions ask you to open the database - probably by double clicking the file. - Then you close the database, but keep MS access (the application) open. - You then re-open the...

An exception list. ie. If I have 10 textboxes: txtbox1, txtbox2, txtbox3... txtbox10 for each ctrl on form if not [in exception list] then ctrl.value = ctrl.value + 1 next ctrl exception list = {an unknown quantity of strings, or variants, or objects, that I wish to exclude from the above...

For proper normalization you may want to consider the following logic and create tables to accommodate: 1 patient can have many complaints Complaint 1 Complaint can have many Calls about it DateOfCall 1 repair can have many parts PartsUsed PartNum and potentially: 1 Repair can have...

Is there a cleaner method of holding an unknown number of strings than constantly redim'ing an array? Is it less process-intensive to latebind in a dictionary.object, rather than constantly changing an array's size?

Looks very similar to what I had - I needed that push up to the top level form though. Perfect - thanks!

Table normalization would make it better... Description / Type / Comp / Year / Value ... Income / X / ABC / 2000 / 111 Income / X / ABC / 2001 / 222 Income / X / ABC / 2002 / 333 Copy it into excel, transpose and fix your data table. You could also use a transpose() function in access, but...

I have a listbox on a subform (or a subform within a subform). When it is clicked I want all other listboxes to unselect. There may be listboxes on the mainform, on other subforms, on other subforms of subforms. I imagine I'm looking at a recursive function of some sort, but I'm not...

:p* sorry... I'm looking for Intellisense features for activeX objects that don't seem to have Intellisense. I have functions or classes in front of me...and I'm tired of scouring the internet for the white pages on this object while attempting to learn exact syntax for its properties...

Add the MapID and a yes/no to your table... ie: MapID / itemname / pointvalue / chkbox Run a query to Select pointvalue where MapID = V**** and chkbox = true, then dsum the resulting recordset into Audited text box. You'll run into a lot of trouble with a continuous form if the checkboxes...

The example form demonstrates how to enter new data into a standard tables and how to enter data into "join" (juncture) tables. You'll need similar features for each standard table and each join table... How you arrange the form or forms really depends on how you want to setup your visual...

Is there a standard method of obtaining an unfamiliar object's methods and properties?

Your first problem lies in the fact that your database is linked to network shortcuts. Get the full server name - use that religiously. People can and will map their network to different (...C:, D:, X:, W:) drive letters. Check your network access - do you have full read/write capability...

Any reccommendations on how to compensate for time discrepancies? ie. Method of adjusting all data input to GMT for a universal display for aggregation? Or forcing front-end to use serverside data for time calculations? or... other suggestions? :banghead:Creating database file logs turned...

When logging time (Now, Date, etc.) - how does access handle Timezones? ie. Will 2 people entering data on opposite sides of the world at the same time have a table entry that reflects 2 different dates?

All calculations are performed at form open without any data input. I'm not sure where I would put that... I've tried adding a me.refresh / me.repaint to the end of my Form_Open...no good.