Search results

I have a report that opens in acViewReport from a command button on a form. When the report shows no data from the underlying query, I want the text "NO DATA" to appear. Currently I have a label showing "NO DATA" with the Visible property set to No. In the report's On Current event, I put the...

I have a query that I'd like to count the number of records. Seems easy enough but, I only want the number of records where the FYID is equal to what I have on the open form Main_F. I'm close, but not there yet. Can someone lend a hand?

How would you set this module up to check for the parent form creation of the ProjectID, (which is the primary key of the parent form)? I have eight subforms where I want to use this. Maybe I just need to place the code in all eight, since the Me.Undo is going to change also? Thoughts? It...

I have a form with some project data on it called F_Project. I want a command button on that form, to open a new form call F_PANumRequest. I only want one record on this new form and the ability to open it again and see what the request is. The F_Project has a record source of T_Project with...

How do I explain why this query is not updatable?

I'm trying to lock down my database after a user went in and changed some table records. :mad: My database is split. The Back End is encrypted with a password. The Front End opens to the Main form. All forms are not able to go to Design View. Also, the FE has the Navigation Pane and the Use...

I'd like to have the ability to delete records in a split database. How can this be accomplished given that the database has forms with subforms and subforms with subforms?

When placing command buttons in a form to navigate to the previous or next record, is it best to use the embedded command buttons for the 'go to next' or 'go to previous', when you want the records to appear in descending order? The reason I ask is, they behave as they should, but to the user...

I have a form with a command button to email a report. The criteria for the report is based on the ProjectID on the form that has the email button. This may be all wrong but it is what I've come up with so far. See code below for the command button. Initially I had a problem with error code...

I have a subform in a tab control that has some control validation. The problem I am having is that it fires on a new record. How do I fix this? The validation control module looks for the * tag to check which controls to look at. Currently only one control has a *. SubmmittalNum. When I...

I have a continuous subform that I want to display the record count in a text box outside the continuous form. See below "Projects found". Note in the footer I made visible the text box "Count" In "Count" is =Count(*) text box name is txtCount. In "Projects found" is...

Is it possible to apply conditional formatting to a listbox? Or do I need to redesign the what's in the listbox to a subform?

I thought I had this figured out but... nope. I have a small database that is split and used by multiple users for reports only. No input into forms. The only input is from a single Excel file that is generated from another online program. I want a way to import the the new Excel file into the...

I'm trying to do the following: From Access create a Word document and save it as a .docx. What I have so far: From Access I have a command button to create a Word Document based off a query. Private Sub Command47_Click() DoCmd.SetWarnings False DoCmd.OpenQuery...

I have a small database that is used by the users, only to get reports. No input. The database is split and gets it's changing data from an Excel csv file. I created a linked text file pointing to the Excel csv file. (I run another program to generate the Excel file) Excel file is lengthy...

When opening F_Project form to a specific ProjectID, I have some code to check if 3 fields are populated. If they are populated, then all the other controls that are Enable No, change to Enable Yes. Otherwise the stay with Enable No. This method works for all the controls that are on the...

I've had this happen twice now in the last 6 months. A user's FE suddenly has the linked tables from the BE removed and all the tables are now embedded into their FE. Of course this is a huge problem as they are now inputting data to their own tables and not the main tables. When it first...

I had a strange thing happen in my split database. Some of my subforms records were not in order. The parent form was fine but the subform would show the last record first. Both forms had tables for record sources. There was no sorting on the forms. I tried everything..... a couple hours...

I have a sub form linked to a parent form. The sub form is a continuous form. It’s record source is a junction table. There is only a combo box in the sub form. Besides having the ability to select a record from the drop down, I want the user to be able to delete a record (after a warning...

I have a combo box in a subform (cboContractNumber) that I want to be able to choose all the Contracts that are not closed. i.e. CloseOut = False. See below. The row source is Q_ContractCombochoose1 as shown below. The issue I have is, when I create the a new record in the...