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

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

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

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

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

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

Hello- it’s hard to find something in the forum if you don’t know what to look for. I need dlookup in reserve I have a user check out the data before they run a report. I can’t automate it because they must come to a decision on how the data must be fixed. Each situation is unique I have a...

I have noticed if I open an empty database, and import everything- tables, forms, queries, reports- the "new" database is significantly smaller then the old one- yet it is the same thing. Why? what am I losing? Am I losing something important?

I have a form opening up in the background. Its job is to check a value every 2 minutes and trigger a chain of events that will shut the database down if I want to make repairs. I want the form to be invisible. I have changed it's properties to visible= "No" I have never had a form invisible...

I have a form that, depending upon a combo box in the header, will change the recordsource of the form to whatever table is listed in the drop down. I have no problem with that. Unfortunately, my form has a continuous subform that shows all entries on that table for easy viewing. I can change...

I would like I have a form and a subform. I would like the control on the main form, when it's done running, to activate a command button in the subform. Subform is 72sort subform the command button is command4 I have tried so many things I don't remember what I have tried anymore. Can...

My employer had used Access 97 to store a database for a consumer relations department. The database crashed often, would not let more then 10 users in at once without crashing again. It held thousands and thousands of records, and bogged down horribly The entire database corrupted when someone...

I was looking here in this message board for a beginners explaination of how Cascading combos work. I didn't find one... but I did find this link to this page. Very cool for beginners (like me!) http://www.fontstuff.com/access/acctut10.htm Cascading combo interdependent combo combo boxes Drop...

I posted before, I had not gotten a response Here is my code : CMID = Me.CombinedID Forms![FRMMAIN]![CombinedID].SetFocus DoCmd.GoToRecord acForm, FRMMAIN.CombinedID, acGoTo, CMID This is on the onclick event of a command button on a subform. the plan is to make the main form "Frmmain" to jump...

I am a beginner to VBA, I know in general what to do (I think)- I just don't know the syntax. I have a main form called "frmmain" I have a subform called "history" History is a continuous form, showing all the records Frmmain has access to. Frmmain only shows one record at a time. I would...

I want to have a user copy and paste a block of text into a text box on my form, and then VBA would pick out the useful information , and place it in the various feilds in the record for the user. (so they won't have to read the text and pick it out manually) The information generally is in...

I tried posting this before, but I have not seen it posted yet, so I will post again. I am trying to import an excel sheet into access. I have searched the threads, and found similar problems, but none of the answers are helping. The problem: I use a macro to transfer the spreadsheet...