Search results

When I try to use this code, I get a type mismatch error. All of my controls are text boxes. I don't get it.

Nice! Your article was perfect. Thanks!

I have a query in which I want to pull the latest entry from another query. No matter how I have sliced it, it returns the latest for all records regardless of the mrid. Here is the code... (Select Top 1 Expr1 FROM NOTEMERGE WHERE NOTEMERGE.MRID = [MRID]) The NOTEMERGE query grabs all of...

So I was correct on the sql code after setting the warniings to false and then turning them back on. I would also like to now have the current form closed and open a new form on the record when the add button is clicked. The cancel button should cancel everything and close the form. I...

I am trying to create a form that will add a record to the bound table and also to the related tables. I also would like to prevent the form from updating until the user clicks the add button. This will trigger the record save and then (ideally) the creation of a record in 3 other tables. I...

Basically I have the following then: Main Report: Job Specific information Sub Report 1: Items Sub Report 2: Notes Or Sub Report1: Items & Notes from a union query? Thanks for the response

Hi All, Here is what I am trying to do. I have a query that functions and shows all the data I want minus 2 fields which I want to show more than one record from. Here is a simplified version: Job PO Desc Items Notes 1 6 test 12-1 blah 12-3 blah2 10-5 blah3 It is possible to have more...

Perfect. I am working. Thanks for the help!

I have a function to open a form based on linked fields. I don't want a user to be able to open 2 versions let alone 16 of the same record or multiple versions for different records. I would like to build in the following functionality: 1. Check if form (MRSTAT) is open If it is, Cancel...

I just thought... Maybe the best way is to not store ths data in the table, but have a field pull the data in the query used for the reports. Is that the better way?

I have a database where I store notes in a separate table where it stamps the username and date and time of the note automatically. I know how to use SQL to select the latest date, but I want to know how to make the field automatically requery when a report is run. It is easy to do on the...