Recent content by chr1stoper1

Hi Folks I was wondering if you can link a table in two access databases and make the link one way only. So if someone deleted a entry in one table it would not delete it in the other . We have a database which someone has been accidently deleting entries from a table . I would prefer not...

Hi Guys I have an excel sheet which I use to populate 3 different tables in 3 databases by using append queries . Recently I had to change my pc and since then before it will append flags an alert telling me it it is about to append and do I want to continue .It does this for each append . Is...

Hi Sneuberg Many thanks for that I was adding it to the second query. I also think the combo box is a better idea than what I was doing and the variable date has given me extra food for thought as well .I may well go back to the beginning and re jig the database a little using the form idea ...

Find the product numbers in the table ... This is just quick rought copy of what I am getting

the database is too big even after zippibg so ill try and make a simplified version

hi thanks for the reply and your help. I did try your suggestion but ive come across a problem . The database has a query of a query .The first query has the product number in it the second doesn't which allows me to sum the qtys . So I don't seem to be able to sum the qtys of the product name...

Hi thanks for the reply I will give it a try ive never ran a report from a form before. The combo box wouldn't work due to the amount of different product numbers there are several hundred.

Hi Thanks for the reply The report is generated from a query of a query . The first query has a date criteria to return only results from this year and also a prompt the enter a product number. Then several fault codes. The query of the query doesn't have the product number or the date and...

Hi guys On my database I have a report that runs from a query which uses a prompt in the criteria to filter the information that is required to populate the report. I have also made a graph on the report that uses the same information to populate the graph. So the report should have the...

Solved that with a simple is not null on the append query ... think I had brain freeze .

Hi guys The append query works great got the macro working off a command button but I have another slight problem now with the data that is imported. I think it must be importing the whole excel worksheet because I have lots of blank entries at the bottom of my table that is being populated...

try that and it did the trick thank you very much for the help

hi folks I'm fairly new to access and am working my way through database problems by building my database with your help and reading former posts. My latest question is how to best import my data using vba or a macro. I import data direct to the tables from excel manually on a daily basis and...

Thanks Brian that solved my problem...much appreciated

Hi Brian Thanks for the reply. I have tried using like[enter detail number]"*" but it says there is something wrong with the syntax