Search results

Hello, for anyone browsing this thread for help, here is how I solved my problem: In the form, I set the Required property of the field back to No and in the form deleted the Is Not Null validation rule. In the beforeupdate property of the form (the form that contains the table fields in...

Thank you, Galaxiom. As you suggested, I included the dbFailOnError argument. For me own informational purposes, would you be able to clarify your statement 'it cannot handle a reference to a Form or Report because it sends the query straight to the database engine'. I have a hard time wrapping...

Hi Catalina, I actually did try code before- I used the code you provided in one of your posts in this forum. Here is my modified message box: Private Sub Form_BeforeUpdate(Cancel As Integer) 'http://www.access-programmers.co.uk/forums/showthread.php?t=182574 Dim msg As String, Style As...

Hello, I have a form where the user hits some buttons to manipulate and clean data in a table. Then, the user needs to have access to the entire table in datasheet view to spot check things and manually make any necessary changes to one field (the rest of the fields are locked). What I need to...

Thank you so much! It worked! Here is what I did in the real database for anyone who might be browsing this thread for help: I put the two non-date criteria in the where clause into the ORIGINAL query underlying the form that opens. Then I changed the date criteria in the vba to match the...

The relationship is one to many: for every PRC2 record (a PRC2 is a document which holds separate invoices), there can be many invoices in the Transactions table. The data I have entered right now- neither of the invoices correspond to either of the PRC2's that are currently in the DocRec table...

Sorry- I didn't set the relationship up when I pasted these tables in the sample db. The only field relating the two tables is Doc ID in Doc Rec and PRC2DocID in Transactions. The form that is supposed to show up when I click the button shows the recrds that have a Null PRC2DocID.

Hello, attached is a simplified version of my databse. It cotains the report prep form, the two tables in question, and the form that is supposed to open when the button is question is clicked. I would be really grateful for any light you could shed on this openform problem. Thanks!

Hi everyone, I am still struggling with getting this seemingly simple thing to work. I read about using the openargs property to set multiple parameter criteria, but I haven't gotten that to work either. I don't understand the concept of openargs, even though I did quite a bit of reading on it...

That is exactly what I was worried about- and that's why I asked about turning off warnings only for the update kind of messages, but not for the error messages. Thanks!

Hi jzwp22, thanks for giving this a shot. I just copied and pasted your modified line into the code and it is still asking me for the Class Code and Date of Record parameters. To answer your questions: Yes, Date of record is formatted as a date and so is the text box into which the user types...

I usually set warnings to true immediately after the action line, but you are right- if execute doesn't display 'you are about to update' warnings at all, there is no need to set the warnings off anyway. Thanks!

Thank you, Galaxiom. I didn't realize that .execute had that advantage. Will keep that in mind when dealing with warnings in the future. Thanks!

Hello, I am confused by why my code is not picking up the where criteria in a docmd.openform line. I have a form based on a select statement (join two tables, Transactions and DocRec, and then select the records where Transactions.PRC2 is null). This is done for dates between two values that the...

Hello, Is it possible to docmd.setwarnings false for some types of warnings but not others. I am running an update query using .execute and before the execution line, I want the warnings to be suppressed if it's just the regular 'you are about to update...' message, but I want it to display if...

Hello, I would appreciate any general advice on how to handle this problem: There are two databases, both access 2003. I need an Invoices table to be linked from database A to database B. I am the creator of database B, but I do not have read or write permissions for database A. The only thing I...

Thank you, Bert! That was silly mistake on my part, which I just couldn't see because I guess I looked at it too much and it was hard for me to step back and really look at the line part by part. I ended up going with a loop in that particular section, but I think it's worthwhile to go back and...

Hello, I apologize if this is a repeat of one of the many threads there are on the error 'object can't support this property or method'- but nothing that I found seems to pertain to my problem and I am really becoming frustrated. I am taking some data from access queries and pasting them in an...

Thank you, spikepl! That worked- all the records that I expect to see are returned. But here is what I don't understand- if the values have been re-typed as exactly .1, .3, and .6, why wouldn't the query pick them up before? And especially since there are a handful of other employees in the FTE...

Hi RainLover, thanks- I tried this out. It runs just as my original 'where TotalFTE=1' condition did: the majority of people selected are correct (all have sum of FTE=1, but the few who were missing with the where clause applied are missing again. I did a bit more investigating on the people...