Search results

Thats all im trying to do. I need a button on a form to run multiple macros that rename a table one after the other. Unfortunately im not the best when it comes to VB Can anyone help please?

HI If i set the print settings (page orientation, size etc) when i have a query open, Access has forgotten it next time i open the query. How the smeg do i get it to remember the print settings? Please help me im running out of hair! Thanks

Hi can anyone help please. I have a form where users can specify crtieria for a query. The value that the user enters via a combo box on a form is entered in a query. The user then hits a button to run the query. Problem is the entry i have in the criteria of the query that links to the form...

Hi I have a combo box displaying a list of values from a field in one of my tables. The criteria of a query is linked to this combo box. So when the user selects one of the values in the combo box, then hits the button to run the query, only the records with that value appear. Works fine...

Hi This is simple im sure but i am a thicky How do you allow a user to enter a value in a form; have access set that inputted value to a criteria in a query? Then ill have a button to run the query which i can do thanks thicky ste

Can you use a form to add criteria to a query? I would be good if i could have a form where the user can add various criteria into a query, then bash button to show the queries results. Is that doable? please excuse my enormous dumbness

Ok this might be basic stuff i'm a bit dumb I have a query showing lots of records of equipment that is in different rooms. I would like to have a form where the user can bash in a room number and all the records from the query that have that room number in it pop up. Please help the dumb

Hi Is there a automatic way i can delete Fields from a Table? This table gets input into the database very frequently as updates come in and i'd like something like a Query or Macro, where i can define which fields i dont want, to delete the 30+ columns of useless data. Can't see how to do it...

Hi i have a query that takes fields from various related tables to give me the information that i want The primary table has 199955 records The query displays only 199939 16 recordss are missing I know why this is: the primary table (CWT reqd equip) has a field on it that is a primary key...

Yes i'm having trouble with a Count problem, don't laugh at me. I've got a query with 200000 plus records. Each record has an equipment ID number (its not the primary key) in column B. I just want to count up the number of records that have each equipment ID code, but im not sure how to do it...

Hi i have a query that shows 190000 records made up from related fields spread over many tables. now i add in a new field to the query. It is related in the same way the others are, and indeed the information now appears in the query matched up correctly. But for some reason the query now...

Hi How do you add up all the values in a column in a query?

Hi I have a select query and im running it with Like "*pendant*" in the criteria of one field so i only get the records that have pendant in this field but i have added another criteria, Not "6077" in another field, so i get records with pendant in field one so long as they dont have 6077 in...

Hi I cant seam to find many examples of Criteria expressions you can put into queries. I now the basic stuff like "like" "not like" and doing anything with numbers is straight forward. Is there a examples list anyone knows listing all of the types of exressions you can input? At the moment i...

Hi Not sure what im doing wrong her. I've a Append query to add 189 rows of data to the data already in a table of about 6000 rows. when i click preview the query says it is going to alter over 1million records!! there aren't that many records in the table, i aslo have a simple update query...

Hi First time posting hope you can help Im totally stumped on two counts. First I run a delete query on a table (that has NO relationships). the query removes a record if a particular field is blank. However it leaves some, about 40 that are blank, and removes 256. Why does it think these 40...