Search results

I have a form that won't fit on one page, and needs a vertical scroll bar. I have a scroll mouse, and everytime I use the wheel, it goes to a different rrecord instead of scrolling up and down the page. Is there a control I'm missing? :D

Has anyone ever imported an XML file into an Access database? If so, what if any were the problems.

Can anyone help me?

I have a linked Excel Sheet in a database, and I'm trying to run a delete query on the data, but I get an error message saying "Deleting data in a linked table is not supported by this ISAM". Can someone tell me what this means? Also, is there another way to get the data out without going into...

Thanks. You have been a huge help.

Well that worked. I appreciate all your help. Now I have another question. I use an append query to export all my data to a backup database, then in the backup database, I have a query with a count function to let me know how many records in the backup. I am transferring the data in the...

I tried it, and it's importing as a query, not a table, so when I try and open it, it is looking for the table that the data is coming from.

I'm not very good with code, but I copied and pasted it, but it wouldn't work because I'm on a network, and it was asking me questions about my user profile. Anyway this can be done in a macro?

Is it possible to get data from a query in another database without linking them?

Thanks for the sample db. It was a big help.

I'm not following you. If I create a form, where does the data come from? Let me try to explain exactly what I'm doing. I ship a lot of UPS where I work. People also ask me for rates. UPS ships up to 150 lbs to 8 different zones across the US. There are different rates for for each zone in...

I realize the spacing didn't turn out the way I expected it to. The 1 is supposed to be over the 2.3, the 2 over the 3.3, the 3 over the 4.4, and the 4 over the 5.5

I don't think I gave enough info the first time. If I have an excel spreadsheet like the one below: 1 2 3 4 5 2.3 3.3 4.4 5.5 6 3.3 4.4 5.5 6.6 7 4.4 5.5 6.6 7.7 8 5.5 6.6 7.7 8.8 I want a user to be able to enter 2 and 6 and access to return the value 4.4. I need to be able to...

I use the yes/no box a lot. If I'm looking for results based on if a box is checked, I create a query and under criteria of the yes/no field type in Like True. The yes/no function stores the data as yes=true, and no=false. I hope this helps.

I'm trying to create a database that uses something similar to the vlookup function in excel. I need to lookup data based on 2 different criteria. Anyone have an idea?