Search results

I have a module in Access 2007 with the code: Option Compare Database Option Explicit Function TitleValue() If TitleValue = 1 Then Auto_Title0.Caption = "All Open 'Critical' Priority Work Orders" End If If TitleValue = 2 Then Auto_Title0.Caption = "All Open 'Normal' Priority Work Orders" End If...

I have a table that is handed to me that is stuctured such that I need to move part of one record from it's row and move it to another record row in the same table. I have included a JPG to help explain this in case the format of the post gets messed up. Thank you in advance for any help. This...

I have a problem that seems easy enough but I can't figure out how to do it. 1. I have a form that pulls from several tables from our MRP system. 2. I need to build a new end item part number from parts in our system. 3. What I want to do is pull a certain record by part number and get all the...

If I had a table and data that I get data from with fields and data like: Clock No..... HourType1...... HourType2 1111 ................1 1111 ....................................5 1111 ................1 2222 ................1 I need my output in a query to roll up the multiple records by...

I have a problem with figuring out how to ignore a variable amount of blank spaces at the end of a field. My VBA code is as follows: Private Sub cmdGetPrint_Click() Dim x$ Dim stAppName As String On Error GoTo Blank Text177.Value = "" ' this is a textbox on my form used for building string x$...

Testing if I can post

I have a simple database that has in the same record in a table 3 fields of last names that are populated by entering the data in a form. There could be the same last names in each of the 3 fields. (ie; John Doe, Mary Doe, Little Doe) My problem is that I want to make a report by clicking on a...