Search results

Prepare to be AMAZED! :cool: Note: the return is a string, it's not necessary to set a reference pointer to the object.

Strikes me as a much less effective method, unless there's an inputbox() gui I'm completely unfamiliar with? the Filedialog is pretty much ideal, except for: 1) conflicts with early versions of references -- I'm not entirely sure where these are, but I know they exist. 2) FileType filters. ie...

What is the most effective way to open a standard save-dialog message box to allow end-user to enter path/filename? Currently using: set oDialog = Application.filedialog(2) Given the above method, I am unable to add filters for the filetype (ie. when used it will always say "*.* | All"...

No problems with the company network; perhaps offsite end-user issues connecting over VPN? I don't have a lot of control over this aspect. Any other recommendations, or suggestions to implement, from a database design/management perspective, that could reduce the above problem?

Replace this line: with these lines: a = CreateObject("wscript.network").UserName LoginName = dlookup("Fullname","OperatorT","OperatorT.UserID = " & a)

It sounds like they just want those values output. ie. set db = currentdb for each item in db.tabledefs output iterate for each info in db.tabledefs.fields output. iterate The alternative is creating a class that mirrors an abbreviated tabledefs. Something to that affect.

Though keeping a database normalized is the general trend and is preferable for a good number of reasons (data integrity, organization, error reduction), denormalized tables can be referenced significantly faster (in certain cases). What this means: Union queries are very very slow. If...

Not really possible. You can take steps to make it more difficult, but it really doesn't prevent the db from being transferred. To protect your code and objects at a minimum you'd need to compile the database (ie. mde/accde). Hide/disable all built-in tables, menus, functional keys...

After auto-repairing and restoring a corrupted database, I discovered an automatically generated access table: I've never encountered a negative errorcode before. :( Anyone familiar with the following...? table: MSysCompactError Fields : Value ErrorCode: -1017 ErrorDescription: Record is...

I think you need a space before VALUES. Try dumping the SQL into a string and debug.print it.

Before you continue you along this route -- I strongly encourage you to forget about complicated un/pw application login tables and simply include a list of usernames. To keep it simple, you could use table fields: username / type ie. "john smith", "user" "GOD", "admin" Now use the environ()...

@pbaldy - gemma was looking at the ChrisO dummy example and not the more recent clarification. Addendum / Clarification to OP question: given the intent: I'm trying to get a feeling for the dangers of running recursion inside error handlers. I would appreciate any feedback or thoughts...

This example is a bit closer to my thinking. Instead of dcount, and field switching I'd be testing for connections to a database and database exclusivity; and then performing a number of...error prone operations to manipulate windows files. It seems much easier - and quicker - to test for...

Alternatively, try strPassword = inputbox("Enter Your Password") if strPassword = "admin" then docmd.openform "myForm"

Is there any reason I shouldn't do the following? I have the feeling that it's a bad idea, but I can't think why... (please move if this is better suited for -> VBA?) ie. function A (param 1, param 2, param 3...) errorhandler if error due to bad param update param resume A(param 1, param...

Why not combine both databases into a single database and hide the timer form?

You have a few options. What are you trying to accomplish by opening it in hidden mode? If you're trying to retrieve or input data, typically you could connect via DAO and not open the database via the application window at all. ie. set db = Opendatabase(nameofdatabase) set rs =...

SELECT Room.RoomNumber FROM Room WHERE NOT EXISTS ( SELECT Booking.RoomNumber, Booking.Arrival, Booking.Checkout FROM Booking WHERE ((([chkArrival]<=[Checkout])) AND (([chkCheckout]>=[Arrival])) AND Room.RoomNumber = Booking.RoomNumber) )

If you need to work with a preliminary "temp" table to store end-user input before "approving" data into the main table -- a few things to remember: - The temp table needs to be on your front end, while the main table needs to be on your back-end. Otherwise, multiple users are going to be...

Thanks. That's much simpler. I completely forgot I could .doCmd from the application... -.-*