Search results

Thanks for all the help - the delete query is just what I needed and it works perfectly!

If I set Allow Additions to "No" I can't add any new records. I do need to do that, I just don't want to see 2 blank records on the form at the same time. In reading other posts, It doesn't sound like it's possible to fix this, just another Access annoyance along with constantly corrupting...

I have a pop-up form in Continuous Forms mode used to enter notes tied to the id field of my main form. Two fields - notedate and status. Everytime I click in the blank field "status" another blank record always shows up underneath. I have "notedate" set to auto fill when the focus is set to...

Finally got it - had to add "AND" to the WHERE clause. strWhere = "WHERE tblContracts.closed = False AND" Thanks so much for all of your help with this! Toni

I understand that it is not good practice to store calculated values in a table, but I am having a difficult time doing otherwise. I have a form with the field "volume". I have a table that stores monthly volumes for each product type. In my AfterUpdate of my "effectivemonth" field I have a...

If I just put another cmd button and use only the Where tblContracts.closed = False, I can open my form with just the Open records. Thanks

Hope this doesn't post twice, but I got kicked out on my first attempt. Thanks for the reply, but unfortunately still no results. I have confirmed that, for the particular search I am conducting, there are records with both True and False results. As I said, the entire code works perfectly, I...

I have a search form in which I need to specify in the On Click of my cmd button WHERE tblContracts.closed (checkbox) is not checked. Beginning of string: strSQL = "SELECT tblContracts.negid,tblContracts.supplier AS [Supplier],tblContracts.agreement AS [Agreement Name],tblContracts.followup AS...

Thanks for the advice on WinZip and the UNC. I have the full version of WinZip version 9.0 and use it to make .exe files, but can't email them through Outlook so I will just mail the .zip file.

I have read every post here on "distribution" and "deploying" the front end to the users but can't seem to get how to do it. I see many posts regarding updating the front end and using the runtime version to distribute but can't seem to understand how to initially get the database out to my...

Thanks, I will try that. My table is normalized, the form is not based on that table, it is just a data table that is used to create the other queries to get to the total volumes for one field on the form. Toni

I have a table "volumes" with the following fields: product, year and one field for each month of the year. I update the data in this table monthly. From that table I calculate a total volume for each "project" through an After Update event on my "Cut In Month" field on my form Right now, when...

I have a query with several criteria SELECT tblProjectDetails.projectid, SubType.SubType, tblProjectDetails.status, tblProjectDetails.product, tblProjectDetails.description, tblProjectDetails.type, tblProjectDetails.producttype, tblProjectDetails.confidence, tblProjectDetails.flatamount...

Figured this out. I had to go into the "MouseDown" event code in the Calendar form and add this: DoCmd.GoToControl "Hours" Works how I want it to now. Thanks for the help.

Here the module that runs the Calendar when the field "Date" is clicked. 'WHAT: OpenCalendar (strSubForm) Credit goes to: Brock W Denys, Coolhead Incorporated 'WHY : OpenCalendar will open the calendar form and send the subform's name if the subform name is passed to this function...

It is set to the Control "Date", the field name is "DateCompleted". Thanks for the idea. Toni

I am having trouble getting the cursor to change focus after updating a field in my tab control subforms. I have a main form with a tab control and 4 related subforms for each record in the main form. I have a calendar that pops up with the On Click of my Date field. When the date is...

I have just switch to a SQL backend, linking the tables to my Access 2000 db and am having difficulty getting my Employee name combo box to retrieve the subform data. No matter what I try from the forum suggestions I keep getting the same error "Object variable or With block variable not set"...

Thanks Pat - I do have Enterprise Manager and I think I'm working off of SQL Server 2003 on our network so I'm going to ditch the .adp, and link my .mdb tables to the SQL db. One more question. My main reason for going to the SQL db backend is that my Access tables were continuing to corrupt...

Clarification needed I am moving to a SQL server backend on our network. I have been reading the posts on .adp versus .mdb and the book MS Developer's Guide to SQL Server but couldn't find specifically how to set this up (Or, more likely, I'm just not getting it). I have successfully connected...