Search results

Hi, everyone. I have a Farm table that contains data associated with individual farms. Each farm occurs within one county and one state. I also have two control tables, a County table and a State table. There is a one-to-many relationship between the State and County tables. In my Farm table...

Thanks, Bob. Will do. In regards to it being "safer" to use ADO rather than this method, do you buy that? I don't see any reason to believe it. Duluter

Hi, everyone. I want my form to save the record only when the user clicks the Save button. If the form is closed in any other way, then discard the changes to the record. I found a thread on bytes.com that addresses this: http://bytes.com/groups/ms-access/835113-force-user-save-form-data...

Oh, super weird. So, this does not work (when in a standard module, run when the form is not already open): Form_frmSample.Visible = True But this does: Form_frmSample.thisvariable = "this" Form_frmSample.Visible = True You can't "open" the form by setting its visible property to true, but...

Sorry, this may be a dumb question, but if I post the db, will it have identifying information in it? Like my Windows username, etc.? I wouldn't want this info in the wild. I am using 2007, but my database is saved as a 2003 mdb file. I have one completely empty form. In the module behind the...

Really? A brief test on my end bears out the opposite. I have a form that is closed with a public variable in it. I have a subroutine in a module with this code in it: Form_frmSample.thispublicvariable = "this" MsgBox (Form_frmSample.thispublicvariable) And it runs ok. Controversy! :)...

So, to open this up again, I'm a little confused. If the form is not already open, you can't do this: Form_MyForm.Visible = True But you can do this: Form_MyForm.APublicVariableInTheForm = "Something" It's strange to me that the module for the form is available, but the form itself isn't...

Yes. My bad, as they say. Thanks, Duluter

Hello. I was wondering if anyone could explain the differences/benefits/drawbacks of these two approaches to opening a form: DoCmd.OpenForm "MyForm", ... and Form_MyForm.Visible = True Duluter

April15Hater: Sounds like you and I are peas in a pod. I'm coming to the realization that I took my strength (coding--a relative strength, mind you) and ran with that rather than fully learning all that Access can do for me with its built-in tools. By doing everything ourselves behind the...

Hi. I've been thinking about creating a log of all transactions in my database as a safeguard against data corruption. If I had a log that consisted of ordered SQL statements, the database could be rebuilt up to the last successful update via those logged SQL statements, right? In my database...

Leigh: Thanks again for the further clarifications. >>"The consensus of opinion (you can trust me on this or not) is that updates and inserts are best performed through SQL statements." Would this be through CurrentDB.Execute? Is that the way to best perform inserts and updates through SQL...

LPurvis: Wow. Nice, detailed response. You've given me a lot to think about. Yes, my database is split into a front and back end (2 MDBs), with linked tables. "Since you're not dealing with open forms here, but apparently immediate recordset updates" That is correct, all of my forms are...

Hi. In my VBA modules, I connect to my data through ADO. I would like some feedback on the way I do things to see if I could be doing them "better". Background: The database is used in a small business, with usually no more than one person accessing the data at a time. Occassionally, there may...

Hi. I implemented a query very similar to one found in O'Reilly's SQL Cookbook on page 367 ("Pivoting a result set into multiple rows"). Part of the query uses aggregate functions (MAX, in this case, though the exact function used is arbitrary) to remove null values from within columns to bump...

This is just what I want. Thank you. Duluter

Hi. I have a report that groups on field X. Under each X, there may be multiple records showing fields Y and Z. X1 Y1_______Z1 Y2_______Z2 X2 Y1_______Z1 Y2_______Z2 Y3_______Z3 Etc. Standard stuff. Now for each group on X, I want to display a label to the left of the first detail row, but...

Whoa. Cool idea. I'll give it a whirl and post back. Thanks, Duluter

I do not have access to SQL Server--at least that I know of. Assuming a pure Access implementation, how would you suggest I go about it? Duluter

Hi. My testTable table has two fields (words and current) and looks like this: words______current ten_________no this________yes half________yes question____yes fibber_______no I want to query the table to find all the words that are "current", like this: words___ this half question But...