Search results

Yes I have already dumped it into excel and created a tab for each (Table) I would want. The issue is its a daily process, and manually manipulating the data into excel and slicing it up to different tabs will take too long each day. I would like to just be abole to click a macro, and it imports...

The issue is that when importing, the import wizzard only sees the first 255 fields. The fields have names that will help me determine which ones go into which tables, but only the first 255.

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

Like I said. I tried everything. I set all default to Null hoping that would fix the issue. I must have missed the setting for allowing edits.

Im just trying to get the frmXHSUpdate form to open correctly right now. I have not created a button for it yet. I was trying to make sure that the form was correct and then I would create the button to open it. When I dbl click that form, I want it too open with all the fields blank. They...

I have not created the main (Switchboard) yet. They just asked me to add the update form. Originally I packaged the entire thing into a runtime pkg. It opened up directly to the XHSDispTool form. Now I am going to create the Main form as a switchboard allow for a choice between Data entry and...

Sorry same error, just different place now.

Still not responding correctly. I attached a copy for you to look at.

Nope I am getting Run-time error '2046': The command or action 'RecordsGoToNew' isn't available now.

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?

Yes you did. It is a beautiful thing now. Thank you,

Thanks vbaInet, that worked. Now I seem to be having a problem with the account number. the account number is either 13 or 16 numbers long. If it is 13, then I need the first 5 numbers, if it is 16, then I need the first 6 numbers. Right now, the 13 one works fine. I get the proper 5 first...

I get #Name? error in the text box.

I appreciate everything you have done. I guess I am not being very clear, and my wife would agree. I have an entry form. It updates a backend Table. The Tech enters in an acct number as follows 8155200016528863 When they hit Tab, or Enter, it automatically pulls the first portion...

No, its working better than what i was getting, which was nothing. I need it to actually pull the group contact from a seperate table based on that acct number portion.

Well that works better than what I was getting, nothing. At least now I get the portion of the acct#. I have a seperate table that lists Group Contacts based on that portion of the acct#. The person is entering in information for a new record, they have the option to send an email to the...

Yes, below is the code used to pull the portion I need to use to determine the email address associated with that CorpSysprin. Private Sub txtAcct_AfterUpdate() If (txtAccount Like "?????????????") Then txtCorpSysprin = Left(txtAcct, 5) Else txtCorpSysprin =...

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