Search results

Well i am creating a form of standard queries that people will run so they aren't actually in the database and can't change anything. All the queries i have created so far worked fine. I create a query I create a simple form. Label, text box and a button I link the source of the form to the...

Ok so we have a spreadsheet with like 15 tabs, oodles of code and triggers and subs that run when you change tabs etc to pull data from databases to populate drop down menus. At any rate...the file is 5mb and we will be generating hundreds of these. So to cut down on space i wrote a macro to run...

I'm at a total loss on how to do this. I have a spreadsheet with 7 fields that may or may not be filled in. The first thing the macro does is read in all 7 fields. when a field is blank i assign it to null. In the database when i run a query on the table to get the result i want, it assigns...

What i need to do is read a number in from excel, find that number. Copy that whole record, add new record, paste that data into the new record and add on new data to the new record. I was hoping it would be easy as ...rs.copy :D but i see now it's not. I've got it opening the table, finding...

I've found it surprisingly hard to figure out how to make the screen focus on the selected cell. Im running a macro that is updating the datavalidation fields. All the data validation stuff is in column AA1, AB1, AC1, etc. After it's done updating, i want it to select and focus on cell B2...

Im probably doing something totally stupid and simply dont see the mistake in my code, but...i really dont know its driving me nuts. Code is below. The problem is highlighted in red with a comment. Sub SendDataBack1stFire() Dim greenTicket As String Dim strSearchCrit As String Dim headers(0...

I simply don't understand why this isnt working and im not experienced enough to figure it out. I've googled at least 10 times and all examples of how to edit a rs show me exactly what i have. Here is the code. Sub pullTickets() Dim ticketNum As String Dim greenQnty As Integer Dim db As...

I have a very large worksheet that is pulling data from about 3 different data sources. One of the tabs is opening a folder, and opening every file in the folder, delimiting the data, then pulling out the info it needs. The problem is, everytime it delimits the data, it asks if i want to replace...

We are having an issue that we have never come across. We sorted a very large spreadsheet of data pasted from access. And we are trying to find values using VLOOKUP.. Here is the problem, for example. 01245 5 01246 5 01247 5 01245a 6 01245ab 6 01246a 6 01246ab 6 01247a...

I have a spreadsheet, a ever gorwing complex spreadsheet. Anyhow, i have a query in access that is pulling data from a table. The database is returning results. But the query when i put it into excel, is simply not returning anything. I have it messageboxing me the sql query im passing to access...

My boss is using an addon, that is corporate, meaning the code is password protected. That she doesnt care about, she doesnt want to see the code, nor need to know how it does what it does. She just wants to be able to CALL it from her own scripts. Shes currently written macros to do what she...

I have the worksheet setup through the data import to pull a query from a database and it works great. The problem is each time i run the sheet i have to go into access and change the number of the query i want to pull before i do the import. I have a feeling its with a sql string but im not...

I have a script doing a lot of things, but the last step is what im getting the problem on and its bugging the crap out of me. I pasted all the relevant code below. What is happening is on the last file copy, im getting a bad file name or number. If i copy and paste the direct path to the...

I have a form created. It displays all the records in the table. In the Form header i put a text box (txtSearch) with a button(btnFilter) next to it. People can type in the text box, then click the button to apply the filter Thats what i want to happen. Here is the button click code...

Im not sure what happened but this module was written before my time with the company. And it has always run. I created a macro to run the module and a bunch of queries designed to update quantities in the database. For some reason the module has ceased to function. In order to make the module...

I am relatively new, ok totally new to access and VBA but i pick up quickly. Im having a problem putting information into access from excel. I basically have a spreadsheet that i have doing various things and formatting data to the way it needs to be to be put into the table. Some of the fields...