Search results

I'm dealing with large Access tables. So every time I close queries Access asks stupid questions if I want to put results in clipboard. If I hit yes by mistake Access gets frozen and it takes forever to be able to do something with it or use clipboard for copying with other programs. Sometimes...

I have two tables. Main Table Branch, ProductGroup, Product Table of Parameters Branch, Product Group, Parameter I need to make report Branch, ProductGroup, Product, Parameter Now. The manager can give directions in three ways 1. Make parameters such and such for these branches 2. Make...

Hi everybody, I've got a new under the gun challenge on Friday. So I need your help again. I have one table having data and one table structured the same way like the first one, but empty. Using the VBA recordset i analize records of the first table. I use VBA because the logic needs to...

Hi everybody, I use regular connection and recordset. By some reasons I can't change the record in a table. I do: rs.Fields(Field).Value = number rs.Update When run got the message Run-time error '3265' Item cannot be found in collection corresponding to the requested name or ordinal...

Hi, I have a qry like this. DELETE T1.* FROM Table1 AS T1 WHERE Item = (SELECT Item FROM Table2 AS T2 ) WITH OWNERACCESS OPTION; It deletes lines from one table picking items from another table. I copied it from another database where it worked fine. Now i have a message "At most...

Hi everybody, I know how to do that using VBA, but I want to figure out if there is a ready made function for that kind of calc. Ok Lets say I have historical monthly sales for the whole year in 12 columns for each product. I need two things that I can easily do in Excel but not in...

Hi Champions, Here is another challenge. My Access DB generates about 200 separated Excel files using Export. Each of Excel files has 3 tabs. If some data is missing, some tabs might be not generated and sometimes if there is no data for all 3 tabs - then the whole file might be not...

Hi everybody, I've got 250 branches. I need to rate them by sales descending. So I did a query to figure out their sales and sort them. Now I need to give a rating to each branch in this table starting from 1000 down. How to do that? If I put the key on it it's not going to be sorted right. Is...

Hi guys, My VBA in access uses ready made Excel files and sends them out as an attachment to the e-mail to 250 branches according to the e-mail address list which is a table in Access like. BranchName EMail WXP Branch.Manager@Company.ca Each Excel file has Branch name as a file name like...

How to count records in the recordset? I tried rc = rs.RecordCount but it returns -1 all the time Thanks

VBA and table design Hi, I just need a general idea how to manage table design with VBA modual in Access. I want to be able to add columns, rename columns or delete columns of some table in Access using some automated procedure. Basically i need to keep historical data and idea is to drop...

Hi Guys, We get data daily from outside database that has duplications. Sometimes I have the same line 3 or 4 times, but all the data is identical in all fields. I did the query that shows me those dups. SELECT Allinv.Fake FROM Allinv WHERE Allinv.Fake In (SELECT T1.Fake FROM Allinv As T1...

Hi everybody, I just need the main idea what to do in this situation. Let's say we have predetermined numbers that we should roundup our purchases. Example list: 1 2 3 4 5 6 10 12 15 20 25 30 40 50 60 80 100 120 150 200 and so on up to 1000000 so if my calculation sais i have to buy 55...

Hi there, I need to export the table from access 2003 into .prn file. By some reasons we use that kind of files for uploading into anther DB in AS400 (which is stupid, but we can't change that). I can't find the option in Acess to export as .prn I can do that from excel but amount of lines is...

Hi, I have a query picking Top 3 of something. Sometimes I need top 4 or top 8 and this is a part of my adjustments. All other adjustments are in the form. I want to make this Top 3 thing as an adjustable parameter and manage the query from the form. I tried diferent ways, but SQL...

Looking for vbs script or something to do the following things during the night time while I'm home: 1. Open the Access DB 2. Run the Delete queiry in Access DB 3. Compact the Access DB 4. Run the macro in Access DB to build and update the new table. 5. Close the DB Thanks to everybody

Hi there, I have long file (1 mil records) downloaded from AS400 as .csv text file. there 2 feilds - shipping date and receiving date. I need to calculate the lead time in days as RecievingDate - (minus) ShippingDate. It would be easy in Excel, but i have too many lines. So there are 2...

Hi, Let's say I have a table Group VALUE A 12 A 8 A 3 A 20 A 1 B 35 B 2 B 12 B 6 B 54 How I can get top 3 of each group in one veiw? Thanks

Pick top$ lines for each item Hi there, LEts say I have a table branch item $COGS we have lots of same items having different $COGS in different branches and all of them are on one table I sorted that descending by $COGS. Now I want to pick for each item only 4 first lines having...

Hi there, I have a big table bringing Access up to almost 2G limit. I need to add a column to that table using a query. I can’t make another table because of the volume. I have 3 columns like Company Division Branch W X P I need to add the column having Company Division...