Search results for query: *

I have a system (fe and be) on a shared drive. It works fine for 2 out of 3 people. the third person, when they try to make a change (bound form), will get a message that the form can't be found. If it was everyone, I would say it is how it was named in code but it's only one person. I...

I am using access 2010I have a sql statement to insert information into a table. If I have dates in date fields, it works fine. If I don't fill one it, I get errors. I've read the posts and tried what was suggested but still no success. Can someone see what I'm doing wrong? My default...

How can you add a key User Manual (word document ) to an access 2016 database Thanks lhuffst

If I have a table that has these fields: SrvChrgSize SrvChrgAmt fld3-2wk 30.00 fld3-6mo 120.00 fld75-2wk 60.00 fld75-6mo 140.00 How would I do the combo box that lets them select the field and corresponding charge? Currently I have 4 columns horizontal but that's...

Hi. Our company is deploying office 2016 to take advantage of office 365. My question/concern is that I have not finished changing all the access databases to the newer versions. Will databases that are version 2003 but running under 2010 still work when 2016 is deployed. Since this is a...

I have an odd request from the customer. One of the fields is total gallons which can be hundreds, thousands or more This is not a problem. Now they want to add another field that shows only the thousands of gallons based on the first field. How do I do that? for example Total Gal: 181700...

I have a navigation form that I want to requery the recordset of a subform when returning from a different form. I'm having a difficult time getting the syntax correctly and need something to help. Mainform with navigation buttons: ShopOpNavigation Errors button on Mainform: Opens...

I need help on how to correctly identify dates from a form in queries. I have MainForm: ShopOpNavigation (used the wizard) Subform: frmReports where the user enters txtFromDate and txtToDate That is fine. Reports: Main Report: Report1 which has only titles for the report, no...

I have a report that is based on a query. the report has Group: DateAdded: No fields and no header but selected with totals Detail:(fields) DateAdded SubmittedBy Mt_NumPassed Mt_PercentPassed MP_NoMtrprocessed DateAdded Footer: (fields) Month totals (label) sum(Mt_NumPassed)...

how would I let a customer update using allow value list edits, a combo box with 2 columns? I can do it fine with one but with 2 it only updates the first column. cboMtrReason Rowsource: SELECT tblMeterTestReasonType.MeterTestREason, tblMeterTestReasonType.ReasonDesc FROM...

Hi. I have a question regarding access navigation forms and reports. I have a form [frmreports] that has 2 text boxes. txtdatefrom and txtdateto in the report query, I use Between [Forms]![frmReports]![txtfromdate] And [Forms]![frmReports]![txtToDate] Running the reports directly from the...

I have a bound form with the following comboboxes DatabaseName FormName recordsource category category = SELECT TblCategory.Category...

I have a bound form with the following fields tblUserErrors Errorid ErrorDate ErrorBy ErrorType (combobox) ErrorComments ErrorPDFLink browse button open button The form displays the records correctly but when they update one record, it updates all of the records for the same thing. Adding a...

If I have a form that has multiple categories (selections), how would I check and save only the ones that they selected? They don't have to fill in every category each time. I set Booleans for each category and when they select the group I set the Boolean to true. On the save button, I check if...

I have a table with many fields such as MT_Size MT_Manu MT_tested RM_size RM_passed Fh_issued FH_Returned If I am trying to do a report that breaks out each of these into groups based on the first 2 letters of the field, how would I do that? the report the customer wants has several sections...

I have a form that has 8 rectangles with fields inside the rectangles. When the user selects a category (combobox), I change the rectangle border color to blue. I want all the other rectangle borders to be white. When the user selects a new category, then I want the newly selected rectangle to...

Hi All, When I remote into my work pc from home and go into access, I'm having a problem with the screen repainting, rendering or whatever word you want to use. I actually have to drag my mouse from top to bottom for the full screen to be able to see the words. This happens after every mouse...

I have several forms that have the same information plus some so I thought it was be a good idea to create combobox with the main category and then based on the selection, have the field display the appropriate fields. I know I can put all the fields on the screen but I want it to look somewhat...

I have a report with several different subreports. What I need to do is keep the header and column titles but show "No data found for this timeframe" (dates are passed in) and close up the white space if there are not any records for that subreport. I've tried the suggestions here and while I...

In our business, we keep track of the days a contractor cannot work (raindays). This is generally a holiday or rainday or it's too cold. The original file is in excel and saved as a .csv file. On the crystal side, I need to count the number of raindays that fall within a certain time frame and...