Search results

so I can't do it via vba? Any particular reason? It's worked previously...

OK... background info...! I have a table with all the data about the hours people have worked since the start of the project, with a marker in there for what week the hours were worked. I need to add to this table every week, so I import the data from our hours system into a temporary table...

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 &...

Right, thank you for all your suggestions - I shall have another play around and hopefully get something working! Thanks again.

Hum... I'm not too sure how this would help. Maybe I didn't explain very well - sorry! Basically on the form I have 100 or so records. In each of the records there are some fields which aren't in the table a, so require lookups. If I used a subform, I would need the subform to appear for each...

The form is continuous though... Am I right in thinking you can't have subforms in continuous forms? Any other ways around it?

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 guys, Just so you know I have now put all the data into 1 table and with a few extra columns so I can still run the reports by week & month, and it works like a charm. Thanks for the suggestions, I really don't know why I didn't just do it like that in the first place! :-)

Thanks for all your suggestions. I shall have a re-plan.

Also, just to check - if I moved the table to the front end and used the CopyObject code there it would make an actual seperate copy of the table, right?

Thanks for your replies. The reason I am having to copy a table is that I have new data each week, but need to keep the old data for back up. Gemma-The-Husky, so, if I use a make table query in the front end of my database, and told it to be made in the back end , would it automatically be...

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...

Seem to have fixed it by copying everything into a new database. Thank you!

Yes, I have.

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...

Only had a very quick look at your problem, but I have come up with this quite a lot - it seems to happen when you are linking tables that do not have a 1 to 1 relationship. In other words, Access can't update the field as there is more than one record which the change could apply to. Hope that...

Ah, dont worry - works like a charm if I put it in the report footer - which is where i want it anyway, thinking about it!

ok... next problem :-) (I know its a bit cheeky using the same post, but thought i'd save the explaination) As I said above I needed to do it on a report - The totals in the grouped bits work fine, but my grand totals (in the page footer) are coming up with errors - any idea why?

Oh. Thats a shame! OK, I shall think of another way to show it - I eventually want a report showing the same thing, so at least I will be able to get it looking right for that! Thanks for your help!

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...