Search results

I have a report with a lot of fields, which is based on a query. The query runs fine but when I try and run the report I get an error: "Data type mismatch in criteria expression" Any idea how I can narrow this down to a certain field? I can't see anything obvious and I have a very similar...

Hi, I don't know if this is even possible, but I was wondering if you could help? I have a form which contains 3 subforms, all linked to the main form on a 'firstname' field. This works fine, but in the firstname selection page (A form which leads to this one) I have an "All" option. When I...

Hi! I keep getting an 'Overflow' error. I've had a look in other peoples questions, but all I seem to find is that the field type might not be big enough... which doesn't seem to make sense for me...: I have a query which runs fine - its a little slow but there is a lot of data and its not...

Hey! Really don't know if this is even possible, but hopefully someone out there will have a good idea that I wouldn't think of!! OK, I have a table which has total hours against a group of about 10 names for each month. I need a report which has the names and corresponding hours going...

Hi, Is there a way to change text to date format? I have text which I have formatted to be in the dd/mm/yyyy format, but it doesn't recognise it as a date so I can't ask it to (for example) show the ones where the date is after another field which is a date (I get an error saying the I have a...

Hi, I have a form with a combo box on. I have set this combo box to look up its records from a query. In the query there are 2 columns. I was wondering if there was a way to filter the combo box to only show records where the 2nd column equals another field on the form. For example, The...

Hi, Is there a way to add a Where condition to a combo box? For example, I want my combo box to show column B from a table, but only where column A is the same as a field on the table. Thanks

Hi, I have a query which is based on 2 tables. There are 28 columns in the query, 24 of which are calculations using fields in the 2 tables and 1 of which is a d-look up. I had 1 link between the 2 tables and the query runs very quickly, however, when I add another link it takes AGES...

Hi! I am trying to work out a bit of code which I can put on a button which will set every record in a column to 0 if certain criteria are met. Example: The table has 24 columns - Named Month01 to Month24. I have made a continuous form with a button showing each of the month names. When I...

Hi, I have a form which, when you click on a certain button, opens another small form (with the original form still visible in the background). This small from allows the user to add and change information about the record they selected. What I want to happen is for when I close the small...

Hi, I have a form which I am trying to filter on open using: DoCmd.OpenForm "FrmAbc", , , "[FieldA] = SomeCriteria") I have used this many times, so am fairly comfortable with it, however, this time I need to filter where a calculated filed in the form equals some criteria. I have named the...

Hi, I have a form (a) where I select an option from a ComboBox which then opens another form (b) filtered for the ComboBox selection. On the form b I have another combo box with the same options as the one on a (i.e. so you can open the form for a certain selection, then change the selection...

Filter changing fields?? Hi, I have something odd going on in one of my forms! Its running from a query, and it a continuous form. There is a combo box in the form header with an After Update code to filter the records for whatever is selected. However... The selection in the combo box...

Hi, I have a form with a vba programmed button. It has been working fine for a while, but I came to use it today and it came up with the following: Run-time error '2046': The command or action 'Copy' isn't available now. The only thing I have changed is that I have added a bit of tried &...

Hi! I am drawing a blank and hopefully someone out there will have a wonderful idea of how to make this better...! I have a form which is running from a query. In the query I mainly have information from Table a with a few bits linked in from Table b. If I create the link with both tables...

Hi, I have set up a bit of code to copy an exisiting table and change the name slightly: DoCmd.CopyObject , "TblDetail_" & PWyr, acTable, "TblDetail" (Where PWyr is an integer which is set earlier) TblDetail is stored in the back end of my database, and this code is running in the front...

Hi, I have the weirdest error occuring, and hopefully someone will be able to throw a few suggestions out there to why this is happeneing. I have an access database which I have been working on for about a month. Everything works fine, however today I made a back up copy of it, and now when...

Hi, I think what I'm doing is quite simple (or at least it should be!), but its got me totally stumped! I have a table with a load of numerical data in, against a month name & year. I have put this in a query which finds the totals for each month/year combo. I have now put this query in a...

Hi, I have tried to do this before but had to go a really complicated route round to get what I wanted... but I was hoping access 2007 had a nicer solution to my problem...! Basically, I have a continuous form with 20 or so fiends in each record. (It looks like a register) What i need to be...

Hi, I have some experience in access & VBA but i have just started using Acess 2007 and I'm coming across a few funny things! I am trying to put logos into a form. The logos are stored in a table as OLE objects, and are included in the record source of the form... however, when i put the...