Search results

Hey, someone showed me code to interact with a web browser. This is going to help me out here at work, and I want to read more. When I do searches- what keywords do I need to put in to find reference material for this? Someone mentioned it was VB for "Microsoft control library". what? huh...

Bwaaaa hahahahahah (evil laugh) I think I found a winner Dim filepath As String Dim FileNum As Integer filepath = "c:\temp\et.txt" FileNum = FreeFile ' next free filenumber Open filepath For Append As #FileNum Print #FileNum, Now() & vbTab & "test" & vbTab & "test"...

Brainstorm HEY! what if I write directly to the text file in VBA? Run through the record set and send it right to the text file..... I remember doing that in excel..... Hummmmmmm........

yup I sure did. then I get the popup saying my wizard is not installed. I followed the pop-ups instructions to go to : Help>about microsoft>disabled items the response in the box is "no disabled items" so the wizard is just not installed. The thing is- is that I am building this for...

update well- my other program did NOT like Excel. I just told my other program to start at the 2nd character and only take 7 characters., for my entries that were 6 characters long, I added a space to the end. bubblegum and twine. Thanks again!!!!

Nope. I high-light my table From menu: File>Export>popup: "Export Table 'Stage one' to...." No wizard, no "advanced" button. It seems it's not installed? I'm in the office. No control over getting wizard installed. Ok- going back to banging my head against my desk. (I was getting a good...

yes, I know,, but Do you have an example? Looking through the forums and help files, I know it goes here, but I cannot find a list of possible, acceptable arguments that it likes. It doesn't like the way I format it. Thanks for your help, I really appriciate it :)

I am exporting a table into a text file for another program to pick up and use. The code below works fine, but the end resulted text adds character 32 " to my results: ------------------------------------------- Private Sub Command0_Click() 'check if file is there- if so, deletes it If...

Yea Something along these lines sounds good. I wanted to keep it simple. Nothing fancy. I was concidering having them enter a 3 letter code- and then use the character number of the 1st to shift all character codes down. (forinstance a A is a 65- so everything shifted by 65, and then the next...

I am building a database with business contacts. Most of these contacts are shared with everyone. However, trying to centralize data, I am going to have personal contacts be placed in the database too. The personal contact is someone the employee goes to for help. When they find someone at a...

duh sorry I was only looking at the VB on the forms.

could not find example I downloaded the database in your example. I could not find an example of the ShellExecute method

This may sound like a dumb question, but your form does have a record source coming from a query or table, correct? I guess, could you give a little more detail?

What I need to do: I am trying to use a desktop macro program in conjunction with access. The macro program it's self is not that versatile, so I plan to have access "Make decisions" on which desktop macro to run based upon logic in VB. What I wanted access to do: I want access to trigger the...

Never mind- solved it- there is no solution Never mind, I just realized that while the correct "year" exsists in Excel, once uploaded into access, it's converted to text, and the correct first 2 digits are destroyed.

I have data that looks like this: 3-KJ56, 1-85L6. I am importing data from excel. (This was exporting from another inhouse database program into tabdelimited, into excel, ect) There are times that I get data that is mistaken for a date: 1-5600 (jan-5600) This is how it is in Excel, before...

It was saying that the file name or path does not exsist. I checked. (including looking for bad characters, an extra space, etc on the path information) Time to go home for the day. *sigh* When I tried this (on diffferent databases), I have ALWAYs gotten this response. Same response. I...

Question, why would this work: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "import Table", "C:\Temp\somefile.xls", True And this does not? Dim Fpath As String Dim Fname as string Fname=”somefile.xls” Fpath = "C:\Temp\" & fname DoCmd.TransferSpreadsheet acImport...

Quesiton I am not as experienced, butI see you did not get a response yet. I am not familar with this function. Does it give you what week number in the year? like 1-52?

Looks ok to me- did you run into any problems?