Search results

I have been working on a query to list all the people that go to the same address. I works pretty well, however I come accross addresses that have a suite or apt number that is included with the other addresses. I.E. Joe, 1st St, Apt b, Anytown, ST, 99999-9999 Flo, 1st St, Apt b, Anytown...

I had two tables, one for Client Names. One for Client Addresses. Since I have found that Client Addresses can change from time to time without affecting the other Client names with that Address, I merged the two tables into one. Now my Data entry form is not working. What have I done? Thanks...

I have a program that is supposed to take the new name entered into "tblNames" and copy the "RecNum" of the "tblNames" to the "RecID" number of the "qryStationsUnused_636" Recordset. It does copy the "RecNum" to the "RecID" but to the wrong Name in the "tblNames" For some reason it is not...

For some reason, I am unable to add records to my sub form I have a two tables tbl Address tbl Clients I have many clients to a single address "Master" tblAddress.AddID (primary key) to "Child" tblClients.AddNumm (normal field) Both are "Number" style I have tried "Data Entry" "Single Form"...

I am developing a program that takes a length of a word and depending on the length will enter the number of letters in the word into the "LtrCode" Field. However, in running the program, it works well until this point. WrdLen = Len(Wrd) MsgBox "WrdLen = " & WrdLen 'I am able to get the...

I am wanting my sub form combo box to show the Cities based on the State Selected in my Form Combo Box. What I have in VBA code after update is... strSQL = "Select " & Me!LkUpST strSQL = strSQL & "FROM qryCity_Select"...

I have develeped a select query that allows me to list in a secondary combo box only those items that are based from the first combo box. However, I need to have the secondary combo box be able to show it's entire list if the first combo box has nothing selected. I.E. IsNull The following...

I have a form "Restock_frm" that I have on close do the following program. Dim Dt As Date Dt = Date DoCmd.OpenForm "DataCheck_frm", , , "[Date] = Dt" DoCmd.Close acForm, "Restock_frm" The form DataCheck_frm is supposed to open showing only records that have today's date on...

I have three tables. tblClient with Client_ID as the Primary Key field no duplicates tblAddress with Add_ID as the Primary Key Field no duplicates tblData with Data_ID as the link field All above fields contain the Client Number. (listed as text due to some Client Numbers having letters)...

I have a form (OfficeSupplies_frm) and subform (OfficeSupplies_sfrm) that I use in keeping track of office supply orders. My problem is that I am trying to get the subform clear the Order and Qty fields so I do not have double orders. While the below program works great when the subform is open...

I have removed the macro, form, Table and all that identifies with Switchboard, however every time I open my database I get a "Can not open Switchboard" error. Is there any object or program I have missed to correct this problem? Thank you for your time and help in this matter Robert M

I create a table that is created my a vba program that list unused numbers (formated as text) from another table. What I am trying to do is get a list of the unused numbers so as to have an easier time of assigning those numbers to the main records. When I pull up the form that is supposed to...

I am using the following VBA to find missing numbers (formated as text) in a list of numbers being used to generate a table of unused numbers. The program runs without flaw from first message to last. However, nothing is being copied over to the new table. The program is as follows Private...

I have removed the switchboard form, table and the command in AutoExec as well as the startup program. However I still get a... "The form name "Switchboard" is misspelled or refers to a form that doesn't exist. If the invalid form name is in a Macro, an action failed dialog box will display...

I have a form that, based on the selection from the Option Group in the main menu, is opened with one of 4 queries being the record source. I am able to do this, but I am also needing to carry over the values generated by the option group that are "Title" and "Mrk". Currently I am using...

I have a database to track records over a set period of time. There are 3 seperate time periods with the same type of date in them. What my problem is, every time the user opens a form(s) and record(s) they must select which time period to work with. What I am wanting to do is at the main...

I am working on a report that will be generated on a monthly bases, and as such will need to have the beginning of the month and the end of the month dates entered on the report. How would I be able to do this, if it is possible. Thank you for your time and your help Robert M

I have the following file to create an Excell Spreadsheet from and Acess Query. Private Sub PrntXLS_Click() If LookUp = "" Then MsgBox "Please Select Attendee via Drop Down Menu" Exit Sub Else docmd.OpenQuery "OutputXLS_qry", acViewNormal, acEdit...

The user I have keeps getting out of the program I developed by 'X'ing out. This closes the program without making abackup. Is there any way of hiding this option so that the user must press the close button in Access or is there a way to automaticaly save and backup the data if the user 'X's...

I have a program that calls for a sub routine to process the records then return to the original routine. There is nothing that is passed to or from this process. Both programs run and do as they are designed to do except when the sub routine is returning to the original routine. "THIS IS...