Search results

Thank you for the quick reply, The form(s) are an output that different people see based on the choices they pick from switchboard buttons. Different people can only see and choose certain outputs from their switchboard. The switchboards are different for different people. Based on who you...

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...

TYVM for getting my brain thinking. I worry myself sometime I got it using a Command button: Private Sub EnterPNcmd_Click() Dim SQL_Text As String SQL_Text = "INSERT INTO costingresultstbl...

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...

Thany you very much !!

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...

TYVM! That works great!! I feel so stupid but thanyou again very much!

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

Wayne, THANK YOU THANK YOU!! That works Great! Wish I could buy you a drink for the fast response! BTW I have looked at the Normalize threads and when I get a chance I will do it but I needed this as a Quick thing. TY Again!

Thank you for replying Wayne I really appreciate it but my problem is a little deeper than that, let me explain. Table Example: FirstNam1 Lastnam1 FirstNam2 Lastnam2 Firstnam3 Lastnam3 1 John Doe Mary Doe JAck Smith 2...

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...