Microsoft Access / VBA Forum

I want advice on setting up tables and relationships. Quick summary... TblProduction contains production totals and various temperatures related to the production process. TblEnvironental contains weather conditions at the time of production. It doesn’t require data from table production but does need to be recorded with each days...

I have a report named jobrpt. It has several reports and I need to be able to select 1 of them and print it off. I have created a form named mainfrm and have created a combo box I have called ComboReports. In row source this is the code I typed in : SELECT ., ., . FROM jobtbl ORDER BY DESC; Row source Type is set to Tables I then created a...

Hi, I have 3 tables from which 3 different forms create 3 different types of invoices. There are only 2 common fields to all tables(customer, employees). I would like to add a sequential Invoice number so that no matter what form is used, the invoice number always goes up by 1. The forms create a new record using an insert query. Would I have...

In the data that feeds the report there are standings 1,2,3,4 etc. These standing can go from 1 to 100 or more. And these can be divided into categories. I want to give the user the option to on show a certain number of places for each category. In the report Open I prompt the user for the number of places they want to show. I then count the...

hi i am new to ms access and i want to develop an ms access application that contains three tables namely quarantine_table,released_table and rejected_table and i created a form called Frm_Sample that takes samples from quarantine_table. within that table i have created an option buttons rejected and released, now i want to update the table...

Trying to create a report from several Query sources, I specify the control source as : =! All I get is #Name? in the report. I am trying to create the report using fields from multiple queries.

Looking for help on code to check the yes no box if a certain selection is picked from the combo box. For example if I pick "Purchased" from the combo it will put a check in the Yes/No box labeled "Purchased Component". Seems like it should be easy, but I'm having a brain fart and seem to think of how to do it. Thanks for all the help.

This isn't a question but more of a discussion point for all of the serious Access Developers out there. I'm curious to hear what everyone thinks about the direction of the market for Access in general. I learned the program as well as VBA in order to develop applications for my own small businesses that I've either worked for or owned. On one...

Hello Friends I want to include a time limit when a Demo Database run. Suppose I want my database run for 15 days and then it must Locked or Not Accept the User. Any guidance for this trick. thanks irsmalik

I have my word document setup with bookmarks and it will print out all of my records each on a separate page. What I am wanting to do is select which record to print and dumping the rest of the records and not save the extra documents. Public Sub btnPrintInv_Click() Dim wApp As Word.Application Dim wDoc As Word.Document Dim rsInvoice As...

Hello everyone, I have a single table, Tbl_ConsultTracker, which I am using to make a query and report (Qry_SearchResults and Rpt_SearchResults, respectively). Though other tables in my database have relationships to others, this one does not. It essentially contains fields "Consult_ID" (Autonumber/PK), "Consult_Name" (Text), "Consult_MRN"...

Hello, I have a error for Sum's in frmAggrSub. I have 4 unbound text boxes in the footer, 1 is a percent of qryProduction so I can understand if its 0 than a error. However the other 3 only Sum entered numbers in the subform. Any help is appreciated Edit: The uploaded file has a default value of 0 in AggrPerc textbox in frmAggrSub. I just...

I need a report to pull data from 2 queries (qryProduction and qryAggregate. Ive started a report but only has data from qryProduction until I see how to combine the 2 queries. I need it to also to only show the data for the form that is open not all records. Thanks

I need advice on how group or relate data within a query. I have repeating data from my first record source. The first source of information stores data on a single row per record, the second however stores data over multiple rows per record. Example of how the query is displaying the data which messes up my report since I essentially have a...

Hello I have the below that I want it to display the data to select to filter but only giving me the option to text filter. Example the filter to list, Houseware, Food, Clothing etc not just give the filter type of "equalts, Does not equal, begins with etc. SetFocus DoCmd.GoToControl "Product Type" DoCmd.RunCommand acCmdFilterMenu End Sub Any...

I need to carry my "stop" data forward to each new records "start" and "stop" controls so they values are equal to begin with. The code below carries only the stop to stop values of "me.txtname.defaultvalue" to the new record. Is there something I can do to the code for it to carry the stop value to the start value as well? Also it seems to...

I have a report displaying the wrong field value. In the form it displays "inches" but uses "gallons" for calculations which works as needed. However when I open in report view it displays "gallons" but it must display "inches" at the minimal or even both would be acceptable. Currently in the form I have the data settings Bound Column 2. Format...

Hello friends. I am making a form to Select Some Records and then send it to Print. I want to use a Form in DataSheet View. Using ComboBox for Selecting a Record from thousands of records. Upon selecting from ComboBox other 5 fields must display. I want to continue it till the required quantity of Records select. Now this form works for...

Hi everyone. I'm creating a database that holds the data for a residential complex. Each month the latest electricity and water readings are taken. I need to calculate the variance and the variance percentage between the last reading amount and the previous reading amount per residential unit. I am not familiar with VBA or anything so need...

Navigation form ("frmNavigation") --> SubForm ("subFormNav") Contains "frmContract" with ID " BrowseTo is working well, but the Where Clause "=182003" fails It just opens with the first Record. What I am missing? Thanks a lot

I'm having difficulty with my tab control. A) Its difficult to switch to the correct tab by clicking it as it might take several attempts so I added Private Sub tabPlantReport_Change(). B) When the button cmdGoToFuel is entered (Its the last tab position to send the tab control to the next page tabFuel) it goes to tabPG, however if I remove the...

i have a combo box that i will choose from the reports i want to view, how can i do that, knowning that i i have made a button to print those reports form that combo box

= IIf( Between #07:00:00 AM# And #04:00:00 PM#), DateDiff("n"(,#04:00:00 PM#)) I am getting "wrong number of arguments" error The result I'm trying to get is...if a time entry exists in that is between 7:00:00 AM and 4:00:00 PM(Formatted in medium time 00:00:00 AM/PM), how many minutes is it between the time that is entered and 4:00:00 PM? ...

Let me preface this by saying thank you in advance, I got stuck with a project at work and know next to nothing about Access programming and am trying to fumble through it. Tables: Badge Date_Of_Incident Description Code Comment Points Drop Date

Sometimes, when opening another form from my main form (via a button), the program will start counting records before opening the form. The count takes 5 or 10 seconds, goes to a count of around 300, and occurs intermittently. Does anyone have any experience with what is happening here? Edit: Okay, this problem was described better by...