Search results

I expect the information applies regardless of what is used as GUI.

SQL is not a database, it is a language. I am guessing you meant SQLServer in your title and other references. Have you searched for discussions on this topic? https://stackoverflow.com/questions/55915385/should-i-cache-sql-database-data-and-query-it-locally-or-have-the-app-query-the

OldValue of bound control returns Null for a new record. That can be handled with the code. Or use condition of If Not Me.NewRecord Then before test for change of value.

What is tblCmbo supposed to help with? Why is TypeID in tblCmbo? What purpose is OldID? They may pull from same field but values should be different because of key links. Want to provide sample data or your version of db?

How different is data for different types of proposals? Is it worth having multiple "sub proposal" tables instead of one that might have some empty fields? If user changes type, have to delete record from one table and then data must be input to another? What happens if you add another proposal...

Copy/paste to Word as normal paragraph or as a table? I do this - build string for display in textbox on report. Use String() to "pad" with spaces to align as columns. And set textbox with non-proportional font. I just tested copy/paste to Word. Have to change font and line spacing in Word...

Shouldn't have to repeat ClientID in Projects. Really sounds like a 1-to-1 relationship. Alternative is to just have Projects table with a field for status: Proposed or Accepted. Or just make it a date field: DateAccepted - no date means never accepted. Build form/subform arrangement or review...

File > Options > Object Designers > Query Design > uncheck Output all fields Or edit the query.

I did suspect could be same person. Scratch what I said before. I just did a test and the default value does show on the NewRecord row. The code works for me. I tested with and without outer quote marks and concatenation - both worked. Why use VBA to set DefaultValue property? Could set this...

arnel, why not post the SQL? I already have the db.

Not seeing any additional fields so no idea why. Post the SQL statement and sample raw data could be helpful. Could provide db for analysis.

It should. "Doesn't work" means what - error message, wrong result, nothing happens? Maybe should be using BeforeUpdate of some control to validate data. Provide your code for analysis (or the database). How are you committing record - move to another?

E9-Tech started this thread. Are you a different person? Really should start your own thread instead of hi-jacking another's. Code provided is setting DefaultValue property. It will do nothing for existing records. For a new record, the value should show when edit is started in another control.

Your code won't even compile because of errors. Although, even with errors, the form opens just fine. Form frm_BR_Maint has code in its module that is totally unrelated. Missing VBA reference: Microsoft Office X.X Access database engine Object Library Why do some modules not have "Option...

You can change the database Application Title in File > Options > Current Database. You can change the file name in Windows File Explorer.

"files" or "fields"? Can change names anytime.

Query Builder is on ribbon Create tab. It has two views: Design and SQL. I am sure you can find a tutorial somewhere.

Provide rest of code, at least enough to test this. Don't know if 365 would be any different from 2021 desktop but I can see the following: .CreationTime .DeferredDeliveryTime .ReceivedTime .Sender .SenderEmailAddress .SenderName .SentOn

SELECT DISTINCT Type INTO tblTypes FROM tblFilaments; SELECT DISTINCT Color, TD, HEX INTO tblColors FROM tblFilaments; SELECT DISTINCT Brand INTO tblBrands FROM tblFilaments; Now go into each new table and define key. If you want to change to autonumber primary key, that will involve more work.

Yes, underscores are okay (see my examples in post 16), although I minimize use because of the reach to number row and MajP's reason. And yes, if you add characters to TYPE the name is no longer a reserved word (again, see post 16). Review (more from Allen Browne)...