Search results

Hello, I'm working on a feature I'd like to include in my database that utilizes the IsLoaded property to check for an open form and complete an action depeding on which form is currently open. I have two forms, both of which can pull Party Information from a Parties table. My problem has...

Hello again folks, I've been driving myself up the wall trying to get this query to add both the values I'm after, but to no avail. Here's my dilemma: My goal is to add two values into a table; one from a separate table and another generated from a function. This is my SQL so far: Every...

Hello, I'm starting out on a new database for my staff to create labels for correspondence folders, and I'm in need of some help. I have an unbound field that I want a command button to evaluate to check the field before moving onto the report. My first idea was to use a validation rule, but...

Good morning, I'm working on an application where a user would initiate a new batch number for a group of records in one table, but would send this new batch number to a parent table. This seems backwards and I'm not sure if it can be done. Is there any solutions that could do this? Let me...

Hello, I'm trying to add a MsgBox to the On Enter event of my control, but is there a way to set it to run only once? Or does this always occur when entering the control? Thanks! Matt

Hello, I'm trying to write a simple If statement for my form that enables a command button only when a value is entered into the text field. This is my first guess: Sub Barcode_AfterUpdate If Me.Barcode = "" Then Me.cmdPrintNew.Enabled = False Else Me.cmdPrintNew.Enabled = True Me.Barcode...

Hello, I'm slowly getting used to the benefits of concatenation, but my question might be a tricky one that I can't seem to find an answer to. In my DB, I have a form based on a query from my main table that displays results depending on which employee the user chose on the previous form by...

Hello, Recently, I've been working on developing a comprehensive search form for my staff to use when searching for records on our database. I found an excellent VBA code example on the forum a few days back (Thanks again gromit!) and I'm trying to get the results of said search exported to...

Hello, I've created a command button that evaluates a query and exports it to a spreadsheet. Now, I have two burning questions that I hope to get resolved in this post. 1) I've successfully satisfied the syntax for exporting the query results into a spreadsheet, but I'm trying to use a...

Hello, I have a command button that opens PDF files stored in multiple folders, but I'm trying to create a customized error-handling message to replace the "Run-Time Error '490'" error that is displayed when the database cannot find the specified file. Since I'm pretty sure that this...

Hello, I'm trying to get a command button to open a whole folder, not a file, based on it's name. I know how to set the code opening files, but I need the syntax on how to open a whole folder based on it's name as there will be many folders. For example, I'd like it to do this...

How to Disable a Command Button for a Group of Existing Records Hello, I'm trying to develop a code for a command button that will disable it as it will have no purpose on previous records. My command button is set up with an Application.FollowHyperlink function that will match the record's...

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...

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...

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...

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...

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...

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...

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...

Hello, I'm trying to figure out how to pull information from one field on my table and have it displayed in conjunction with a preset text value as well. I have a small DB that will create invoices for document reproduction jobs in our office. My vision is to use a bar code (which the font...