Search results

I typically use DAO a lot. I do use plenty of bound forms, plenty of unbound forms, and use recordsets to update join tables when needed. I saw some references to custom data types in some of the posts and such and in fact, in the Resize Form example updated by isladogs uses custom data types...

Current Login setup: 1. open app 2. Autoexec checks for me 3. If normal users, open Welcome form. a. check version info, update if necessary b. initialize temp vars c. get user name, id, dept d. hide nav pane, ribbon e. open Logout timer form, which stays open f. if the...

In essence, then, I could define a data type, such as User, and instead of using queries/SQL/lookups to retrieve that User's data, and perhaps corresponding data in a related table and use it globally, as long as the data type is defined Public?

Quick question: what is the benefit of declaring and using a type? Private Type with stuff here... End Type

@Pat Hartman It sounds like you have a form open (like a menu/switchboard) while you are developing; and when it closes, your code backs up your files. I could probably find a way to do that as long as I don't hit the 'Close all'. I would like to know how you export your objects to text, and...

Yeah, I get that! :) However, I am not currently running a production version yet. Have not even split it yet. I suppose I should preface this with 'I basically go with the rapid design/development (prototyping?) idea.' Meaning - I design, build and test all at the same time, basically...

I have a couple of questions to post here. I am working on a sizable project and would like to be able to switch between Dev mode and Prod mode easily. I am considering creating a table with version numbers and using a module descriptor such as 'INV' for the main Inventory objects. Then, I...

I am working on a re-order process for a new app. I am combining our inventory app with our request for purchase app. Many users have requested a 'click to re-order' function, but with the new setup, I have some difficulties. Attached is a picture of the tables in question. What I am...

Thank you @MarkK and @Cronk for throwing a wrench in going with Tempvars! :) I think I will start with the TempVar approach, as it fits the style of coding I have been doing. However, I would like to learn more and possibly convert this current program to a OOP...maybe. I will have a look at...

Referencing this page: https://www.access-programmers.co.uk/forums/threads/tempvars-vs-type-variables.315649/ May I ask your opinions as to which may be a better option for my database? I am building a program that several departments will use: for inventory, for ordering, logging repairs...

Yeah, that'll work! Thx!

Hello all, I just came across an interesting situation. I open a record form from a list of records, opening it using the docmd method and setting as read only. In the Load event, I disable the subforms until the Edit button is clicked. However, I found out that if I click on the subform...

Oh dang... I had two versions of code using file dialogs, somewhat integrated, and one version specified using ".pdf" rather than "*.pdf"... Oops! Where's the face palm when you need it? Thanks guys, sometimes just a quick discussion is all it takes to see the obvious mistakes! Well, now an...

Check my edits just above, as I added this in.

As in: .Filters.Add strFileTitle, strFilter? .Filters.Add "PDF File", strFilter simply throws an error: Error 5: Invalid procedure call or argument.

Greetings, Is it possible to use a variable for the dialog filter, i.e.: strFilter set when the function is called via button click, instead of "*.pdf"? I would like the user to be able to select which type of file they want to add, but the Filters property does not like my string variable...

Thanks Pat for the explanation. And that's where the 32/64 problem arose: the Windows API. If I want to use the API with a 64 bit version of Access, I would need to add code to handle that version, correct? Thanks to Doc, Colin, zero and Shrek!

Right. Come to find out, corporate had some issues and installed 64 bit instead of 32 bit on a bunch of machines. Moving to 32 solved the problem. Thanks.

Richard, We are in the process of moving to 365 as well, and I would like to know what you did to solve those errors. My first few users just called me today with an error message similar to what you posted, but after clicking "OK", I got the "Stop All Macros" pop-up. I haven't been moved...

Also, the responsive speed. The my info button, preferences, messages button, and the Members drop down is really neat as well.