Search results

Oops! My apologies. My question has been answered so there's no need for this thread. Sorry about that!

Hello! I have a tricky task I've been asked to work on (tricky for me at least) and hopefully I can get some advice. I have a form that creates a record for each mail item received. For each record, my staff scans a cover letter of the item and directs it via e-mail up to higher staff. Now...

Actually, I have a similar question that just came to mind regarding this task. How would I get the form/subform to display the information for all records as well? This way users can look for records with the section or simply look at all of the records for every section. Thanks again!

Excellent. The combo box wizard helped greatly. I will keep the FindRecord option in mind though. Thanks fellas!

Hello, I have a combo box in a form that lists each section of my office. My form also contains a subform that lists specific criteria per section. I'm trying to get the combo box to go to the specific set of records in the subform when that section is clicked. Currently, the combo box is...

I figured as much. I'll work on getting a sorted procedure to reorder the records. Thanks!

Hello again, I'm trying to figure out if I can set the OnOpen event to go directly to the last record that was edited. I know how to set it to go to the last record, next record and all that, but since I'm working with a table that has a list of preset numbers I'm hoping Access has a way to do...

Luckily, I'm familiar with all the ways access can inadvertantly add records. I've already set the properties in this form to restrict adding anything. Users will basically modify only one record to pull up the information. Thanks!

Excellent suggestion Bob! I tried this method and it worked perfectly! Now I won't have to take my staff on a tutorial every time they need a report = ) Thanks again, Matt

Hello folks! I have an odd situation this morning that I'm hoping to resolve: I have a DB that creates reports based the criteria met in a query (big surprise). This particular report is created once a week with a deposit number that changes every time a new deposit is made. Now comes the...

After messing around with a few expressions, I've figured this method out. I didn't think to add it to the OnClick above the initial function (As I thought that you could only assign one "DoCmd" action to each sub). So much to learn... Thanks again!

Should I apply this to the button's OnClick event, or to the form's After Update event? Currently, I have code set up on my "Print Invoice" button that specifies to print only the current invoice: DoCmd.OpenReport "InHouse", acViewNormal, , "[JobNo] = " & Forms!InHouseForm.JobNo If I add...

Hello again, I'm trying to get a button to function while the current record is open and apply all the changes made to the record when it is printed. I have a form where users can enter an invoice for each copy job they complete. My problem is having the "Print Invoice" button actually apply...

This is exactly what I was looking for. Thank you good sir!!!

I'm trying to figure out a way to add 3 fields together but will still calculate the total if 1 or 2 of the fields are left blank. I'm hoping to avoid using zero values for the blank fields if possible. Is there an expression or code that will add the subtotal of these 3 fields and ignore 1-2...

Any solutions available for the description in my last post? I basically would like for this field in my new form to contain the calculated total for each deposit number group, not the individual amounts of each check. Is there a way to achieve this without creating a group total field?

Bob, you are my hero haha! Works like a charm! Thanks again

The OnClick event for the button is set to it's default action when clicked (created with the command button wizard). The names of my controls are as follows: Invoice Number field - [Inv#] (This is the Primary Key, Autonumber data type) Form Name - [Invoices] Button Name - [PrintInv] Report...

Hello, I have quick question about a task regarding reports. I've placed a "Print Invoice" button on my form that will print the report or invoice of each record. I'm simply trying to set the DB to print only the form's current record when the button is clicked. When clicked, the DB is...

Excellent! Works perfectly now, thanks fellas! :D