Search results

Linked by recordsource criteria. No I wasn't using a requery. Would that work in data entry mode?

I have a form with a subform on it. A field(combo box) on the form will determine the value of a field (text box) on the subform. (Basically its an auto-generated case number that uses the plant field on the form to determine the prefix). The code to automatically generate the next case number...

I was really hoping to keep the data all in one table so it wouldn't be redundant. Also, I was trying to get the loading of a new record as the trigger for running the code rather than write new code just for that situation. This code is written to be modular so that for whatever reason it runs...

Thanks for the idea but actually I was referring to printing it out.:)

I have created a Medical Leave Case Management db and I am trying to have the db assign a case number automatically. The case could have a U1 or U2 prefix depending on which factory it pertains to and that will be based on a field on the main form (frmPersonalEntry). The case number will be...

Well nuts. That's not the answer I was hoping for Pat. Thanks for not letting me waste any more of my time attempting the impossible. P.S. How's the book coming?? :D

Can anyone tell me if you can force Access to resize a report to fit one page like you can in Excel regardless of the amount of data?

Thanks Jack! You got me pretty close. The one that ended up working was actually: CurrentDb.Execute "UPDATE ztblCCCFinal SET OCY = '" & dimlistvar & "' WHERE '" & matchvar & "' = '" & matevar & "'" I appreciate you taking the time to help me with this!

Jack, Here's something that might be of help. When I change the syntax to: dbsPLO_Load.Execute "UPDATE ztblCCCFinal SET OCY = " & dimlistvar & " WHERE " & matchvar = matevar & "" The right values appear to be in the variables and I'm not getting a syntax error. Instead the following error...

Jack, No luck with that attempt. There are actually three variables in the line: dimlisvar, matchvar and matevar. Does that change anything?

The problem with that is that the values in this line of code are from a larger module that loops through a recordset. They are variables so I don't think that I can just set it up in a query window.

Can someone tell me what's wrong with the sytax in this statement? dbsPLO_Load.Execute "UPDATE (ztblCCCFinal) SET (OCY = dimlisvar) WHERE (matchvar = matevar)" I keep getting the error "Syntax error in UPDATE statement" no matter what I seem to try! Thanks!

I think I know how I'm going to do this, I just need to sort through the code. If someone has something similar to send me and save me some time it would greatly be appreciated (I have a lot of coding experience unfortunately little experience using code to manipulate recordsets). I am first...

OK. I'm going to try to explain myself a little better. The data in the table will be grouped according to similar values in three levels as seen in the above post. All the values in the fourth field are listed in the report in a column under each other. An example would be that on the report...

Dave, Thanks for the info. I think we're headed in the right direction except the numbers I'm joining together are not different fields. They are the same field with multiple values under those categories. Hope this makes it a little clearer. Thanks. Any other ideas?

I have a query that generates grouped data following the general outline:(ignore the hypens - they are just to space out the headings so it looks representative of the structure) (Column Headings)-----Line1------------Line2--------Line3 Product ---Quality --------Type -------------...

I have used the above code suggested by ghudson to hide the menu items/toolbars in a database I have created. I have just recently gone from using a swichboard to a custom menu. How do I use the above code but still enable my custom menu?

Worked great Jon!! Thanks for your help!

Jon, Thanks! That code worked great ....except it uncovered another problem I have. When the last day of the month falls on a weekend, there are no entries. Is there any way to modify the code the look for the last entry of the month with data? Thanks again!

This sounds like a amateurish question but here goes anyway. I am trying to get the records from a table with entries for every day of the year up until present. What I want is the last entry for each month and all of the current month entries. I have considered several possible avenues but...