Search results

A few ways to go about it... pseudocode as follows... run: "runas /user:username@yourdomain.com explorer" OR declare an object, open up a command window: "net use \\server\share <password>> /USER:\\LOGONSRV\USERNAME" You'd save the appropriate server password / domain in Access, and...

Correct me if I've misunderstood... Given your data: You have 2 sequences you wish to "sum up". A-A-Bx2-C-Dx2-E (Uniquely ID'ed as : group 1) A-Z-Y-X (Uniquely ID'ed as : group 2) You want query / code assistance to auto generate the two groups above?

Fact: You have < 2 months. This is not a significant amount of time. A few things to keep in mind, beyond the technical specs: You are building for an audience that, more than likely, has less experience with MS Access than you do. Result: your GUI must be more user friendly - more robust...

Private Sub Tablecloth_Click() If [Forms]![Bare campsite Data Entry Form]![Tablecloth] = TRUE Then [Forms]![Bare campsite Data Entry Form]![Tablecloth_hazard] = 12 ElseIf [Forms]![Bare campsite Data Entry Form]![Tablecloth] = FALSE Then [Forms]![Bare campsite Data Entry Form]![Tablecloth_hazard]...

Took a quick glance... Tables are not normalized. You have several lists of things, a list of Services, a list of accommodations. These you currently include in tables - each as an individual field. This should be corrected if you intend to use a Access database -- otherwise, should work fine in...

ie. End-User does not directly access the file. The file is opened by Access - all credentials are stored by Access, not by the enduser. VBA pseudocode: if EndUserCredential=True, allow Access to open file, else don't open file. if George "passes inquiry" to another end-user, Paul...

Feel free to correct me, but this doesn't make any sense at all. The security issues present when applying standard network are no greater than any of the other options you've described - quite a bit less, really. You make a network folder, you assign it appropriate security, you give the...

ElseIf (1Len(2Nz(3Me.Associate_name, ""2)1) = 0 And Me.Status <> "Expired"0) Or (1Len(2Nz(3Me.Associate_name, ""2)1) = 0 And Me.Status <> "No longer eligible"0) Then MsgBox "Please enter Associate Name" Me.Date_authorization_expires.SetFocus At 0, your elseif ends. The Or then becomes...

Try adding the following option to the top of your password module. Option Compare Binary edit: this will replace Option Compare Database.

Reminds me a of a typical family tree, but instead of tracing back through parents, you're tracing back through parent (former) processes. You simply iterate a loop from your origin process to the preceding process. Please clarify what you're trying to do... Also: This is not good. No...

For a more formal approach to object naming, google: "Leszynski Naming Conventions"

Not sure how your tblPayment relates to anything else. Is there a foreign key you didn't mention? tbl_Payment: date / type / amt / chkNo Above fields do not relate to any person, nor do they appear to have any unique identifier (aka. PKey) Given your problem description, it should be...

The CSV is normalized and is good. I'm pretty sure you can simply import as is, view as a pivot and move your Balance Type to the top.

You don't make a field that automatically updates. You make an UPDATE QUERY. Run the query, it updates your table data. An alternative solution is to keep your historical data and APPEND new data to your table using an APPEND QUERY: ie... tblStudents...

Most scanners have built in functionality that allows you to select the option whether an "ENTER" key is defaulted ON or OFF. Read the scanner documentation. If that fails, I think you can add an event at the end of every combobox update to simply move to a new records / add a new record.

Please google: "Access Database creation steps for new users" Read the first 10-20 links. Come back with any other snags you encounter.

As mentioned - all front end databases (forms + queries + linked tables only - no tables) should point to a single back end database (tables only) housing all data. A poor man's fix for version control: Change the name of the Backend every time you want to force users to download a new...

It's also possible the front end has tables on it. Shared temp tables due to shared FE. Bad idea. I recommend dividing the database into 3. Your data backend. (located on network) - store data here. Your development frontend. (doesn't matter where it's located) - make all changes here Your...

If I remember correctly, DoCmd.TransferText defaults to comma as a delimiter (aka. comma separated values - .csv) Add in a VBA string to replace all semicolon's in your source text file with commas and try again. Link to function you want...

SELECT Table1.Col1 FROM Table1 WHERE Table1.Col1 NOT IN (SELECT Table2.Col1 FROM Table2)