Search results

I have one form - just one - where the find and replace dialog will not open when Ctrl F is pressed. This database has dozens of forms and it works just find on all of them except this one. I'm using Access 2016. Is there a property somewhere I need to look at? Thanks

I am trying to create a report that shows monthly totals and YTD totals. I also need to show monthly totals of jobs that were not approved. Here's initial query: SELECT [Carrier Release].[Job Number], [Carrier Release].Supplier, [Carrier Release].[Date Eval], [Carrier Release].Approved...

I know you folks have seen this question a hundred times but I need to ask it anyway.:p On my report, if the shipped quantity is equal to the order quantity, I need it to display 0 in the field. If it is not equal to the order quantity, I need it to display the value of the shipped quantity...

I am trying to duplicate the record on a form and at the same time, add values to the new duplicate record that are not displayed on the form but are present in the table. For example, the form fields are id, job number, order qty, mfgdate and po number. I'm duplicating everything except the...

I have a form with a tab control that has 3 pages. The master job number is entered on the first page, along with some other info. I have subforms on each of the second and third pages on the tab control. I have the master / child fields set to populate the job number field on the subforms...

I have never seen Access do this before today. I've been working on this database for months - it was working fine just a couple of days ago. But today, Access has started closing completely after I open the VBA editor, make a change and close the editor. It's not a crash and there is no...

Hi everyone, This is what I am trying to make happen: User enters data in [Input Table].[Evalby] field - in the After Update event, I open a form, asking the user to indicate whether the job is complete. If the user clicks the YES button, the job status update form opens and allows the user...

I am using a form to pass a date range to a query and running a report based on that query. On the report, I have a calculated field to display the date range. Here's the control source: ="Date Range: " & [Forms]![NCRs by Technology]![TxtStartDate] & " to " & [Forms]![NCRs by...

I have one crosstab query that generates these results: Vendor Total Jobs Jan Feb Mar Vendor A 1 1 Vendor B 12 6 6 Vendor C 7 2 2 3 Here's the SQL: TRANSFORM Count([Subcontractor jobs].[Job #]) AS [CountOfJob #] SELECT [Subcontractor jobs].[Vendor Name]...

To facilitate the import of an Excel file, I am using a button on a form to open a Windows dialog to allow the user to select the file to import. Once they select the file and close that dialog, another button click actually does this import. This all works great except on two particular...

To run this report I have, a form will open on which the user will select a start date and an end date, then enter a number that will be used in a calculation on the report. The control is unbound and the value is not stored in any table - it is used for calculation only and is determined by...

I am constructing a form with multiple calculated fields from multiple queries. The form itself is not bound to a record source. I got one field working with DCount. However, the other field is giving me a #Name error and I cannot see why. The control is a text box named TxtNCRjobs. The...

I have a query which returns all the jobs that have an NCR associated with them: SELECT DISTINCT [Non Conformance].[NCR#], [Production raw data].jobnum, [Production raw data].start_date, [Production raw data].end_date, [Production raw data].jobname FROM [Non Conformance] INNER JOIN [Production...

For the life of me, I cannot tell why the if statement below (highlighted in red) will not work. I have been running it through the debugger all day but I just am not seeing it. I am trying to add records from a spreadsheet to a table. I need to exclude records with a sales class value of...

Would someone be willing to point out my error in this DCount expression (highlighted in red)? I can't see the mismatch. Private Sub TxtEndDate_AfterUpdate() Dim dStart As Date Dim dEnd As Date Dim strSQL As String Dim lNumJobs As Long On Error GoTo ErrProc Set db = CurrentDb() Set rs =...

I'm using a query to try to count the number of records in another query that have a value of zero. But, when I try to run the query, I get a message that the expression is too complex to be evaluated. NumZero: Count(IIf([Quantity Scrapped]= 0,0)) This doesn't seem that complex to me. What...

I have a text string in an Excel spreadsheet that I am trying to split into a start date and an end date and store them in the start_date and end_date fields in an Access table. The string looks like this and is always in the A7 cell of this spreadsheet: From: 3/2/2018 To: 3/8/2018 I am using...

[SOLVED] Extracting data from Excel I am using the code below to extract data from an Excel spreadsheet that is generated by another program. It's all working except for one thing. Please look at the section in red text. I need to make a comma separated list of those bulk ids and put them...

[SOLVED] Importing non-contiguous ranges from Excel This is actually a two part question - I need to import several fields from an Excel spreadsheet that is generated from another program. The spreadsheet is always on the user's personal mapped drive - call it the U: drive, since all the...

I am trying to implement the Front End AutoUpdating Utility that has been so graciously made available by Bob Larson. I am trying to run it on a network with a fairly strict group policy. Every time the code gets to the point of running the batch file, it stops. The batch file is created and...