Search results

How would I go about importing 850 fields into access (Multiple tables) with its 250 field maximum?

I have a folder that has varying text files on a daily basis. I currently have a macro that imports each file, depending on which file it is, and appends it to a permanent table. I then use the table to run some queries, then delete the data in that table, and go on to the next file. Some days...

I want ot be able to open a form that a tech can use to search for and update records. The initial opening should have all fields blanked out until the acocutn number is entered in. I can not get the form to open with the fields blank. I have used DoCmd.GoToRecord acDataForm, , acNewRec I have...

I have a text box for a tech to enter in a MAC address. I want to be able to force the format to be with ":" ex. 11:22:33:a2:b2:66 even if the tech enters in 112233a2b266. How do I go about this?

RESOLVED!!! Text Box Entry I have a text box for account number entry. After update I have an even that populates another text box with the portion of the account number I need. I want to use this posrtion of the account number to populate an email address. This email address is specific to...

I have a form that is for inputting new data into a table. It works great, except when you go to enter in any new records after the initial record. I have a button for updating, and after the button is hit, it clears the form for the newxt entry. If I put in new info, and fill out every text...

RESOLVED!!!!! Text Box Value not printing on Report I have a txtBox (txtAcct#) on a form that once entrered on the form I can use to populate another txtBox(Acct#) on a report. It works great using the unbound txtBox Control Source =[Forms]![CblCardDispoTool]![txtAcct]. I can open the report...

RESOLVED!!!!!! Combo Box visible I have a form with 9 combo boxes of different data. They are all 9 invisible. Depending on which selection is made in a different combo box, then the corresponding 1 of the 9 combo boxes becomes visible with that list of choices. The problem is when I make a...

RESOLVED !!!!! Email individuals Info I have a quick question. I am using the following code to send the contents of a record set row to email addresses in the contents of a different row. Set rstAM = New ADODB.Recordset rstAM.CursorLocation = adUseClient rstAM.Open "Select * From...

RESOLVED -- Access 2007 Qry to Excel 2007 I know this has probably been asked and answered multiple times before, I have spent the better part of the day trying to find an answer to this, even searching on here. I have a query that I want to export as raw data. I have an email aspect that...

I wanted to know if it is possible to embed a pivot table (from a query) in the body of an email. I know how to use VBA to embed data from a table in the body, but not sure how to incorporate an entire pivot table, or if it can be done.

Moved to Forms::::::Email using Access I wanted to know if it is possible to embed a pivot table (from a query) in the body of an email. I know how to use VBA to embed data from a table in the body, but not sure how to incorporate an entire pivot table, or if it can be done.

RESOLVED - filtering Report on the Fly I have a form with 5 fields. The 5 fields are choices from the columns (20) in a table and the person can select which fields they want in the report. If the person selects "Supervisor" as a field in any of the 5 combo boxes, then I want another combo box...

RESOLVED .. 12:00 AM or Midnight I have employees in my database who work from 3:30PM till midnight. I am using a min or max to pull the employees time in and time out for a report showing the employees and there schedules. Right now I am using 11:59PM because if I use 12:00AM, it throws the...

RESOLVED Combo Box I have a combo box that lists Employee Last names. I have some duplicate last names. The combo box selection will populate a record for that employee so it can be updated. The problem is, when I have duplicate last names after selecting any duplicate last name it reverts the...