Recent content by waterdamage

Filtering information The real problem is when you filter one column for criteria; all columns are closed up to the amount of criteria that has been found in the filtered column. I think there must be a different way of doing this but I just can’t see it. Help anybody

OK this is the file; I hope you understand ware I’m trying to get to with it. I just need to keep track of costs of ongoing jobs, any suggestions please.

Thanks for bearing with me I will do it tomorrow and post it up

Thanks for this; I’m starting to think that programming in VB is the key to everything. Tried last month to set up a DB, invested about 2 weeks into it, then decided that I didn’t have the knowledge to complete it so put it to one side and went back to my spread sheet. Now I’m trying to get...

Option one is Ok the criteria is a job name and will be quite familiar to me by the time i wont to do a search for data.

Thanks this works however! I’m trying to get the data from the dial box to change the criteria (at moment “Jim smith” this was recorded) Tried pasting your info in lots of places but can’t get data in the VB code any ware? Range("C2").Select Selection.AutoFilter...

Hi, I won’t to build a macro that I can stop and enter a search string to search my table, can anyone help. I can record most off this but can’t work out how to stop the macro and get it to prompt for the search string

I have been building my DB and learning everything from scratch. If anybody could give me any advice as to where I may be going astray, it would be much appreciated as I feel like I've hit a brick wall. I run a building firm and need a DB to look after customer information, write estimates...

My new form won't paste all the data into the table, only the first two fields will go in, the other fields are empty. The other fields are brought into the form automatically from another form. Is there something I have to turn on to get this data to go into the table?

Over the last week I have played extensively with crosstabs as it has been suggested that this is the way for me to go. As suggested in the forum, looking through sample dbs is a good way to learn. I have found that the way the MS sample db Service Call Management.db ( attached if you don’t...

I have a test db that I have been able to build a Customer Table Estimate Table Items Table I have successfully made a Form called customers that has a sub Form called estimates linked to it. This works perfectly displaying the customer and the linked estimate information. I have a Form...

Thanks very much for taking an interest in what I’m doing, yesterday when I read your reply “bingo”, and went off and played around with crosstab queries, now after staying up most of the night and spending time today, with my wife looking at them I’m not sure that they are what I need. I must...

Thanks for the reply. Maybe I’m going around this the wrong way. I want to produce a printed document that will end up as an estimate. I want to be able to enter data and have a price display to the right of the data for totaling later. I may want to do this several times building the...

I don’t want to show a field when it is empty. Can anyone help me with this small problem? Using expression builder what expression do I use to not display the filed in my query if the field is formatted as currency and is blank (showing £00.00)

Hi, I’m new to access and I have read through a couple of books but still struggling. If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or I’m assuming that that...