Recent content by BenW

Unfortunately I got the same result of a blank report. I am aware of the possibility of other errors, but I've worked out a queries that pull out records with the same date and invoice number entered and the only difference I see thus far is the criteria. I suppose I'll take jag's advice and try...

I currently have a query that is supposed to pull out customers with a particular last name and I would like to know if my criteria is correct because when I type in a last name into a text box named txtLastName on the form FORMCusSearch and hit a button to preview a report in order to see the...

I currently have a table with a lot fields. I was wondering if it was inefficient and I should try breaking it apart and sorting it more accurately? Fields included are: First name, Last name, invoice num, date, customer ID, cost, sale, net, face, received, and notes. I read the article on...

Thank you very much! The website you linked me to was very helpful and helped me get the job done!

How do I get to the load event or view the data entry property? I went to design view on the form and right clicked on the form then clicked on properties but could not find anything on data entry. Sorry for the dumb questions, but I can't find anything on this in the help file either. I am just...

Thank you for the help, but I'm not very proficient with access to know where to type this yet. Where would I place this? I assume I'm supposed to put this on the button property that opens the form inside the event code? I tried to do a ctrl+f of 'load' and 'event' but I could not find a place...

I currently have a form set up to type in information into text boxes that will be stored on a table. The problem is that when I open the form, it is automatically at the first row, so I have to manually go to datasheet view and scroll to the bottom of the datasheet and click on a blank row then...

Ok. I think I fixed 2, 3, and 4. The reason I put text for the company ID was because it was originally a number system, but my parents told me it was too difficult for them to remember a company by number so they preferred using text abbreviations for the company's ID. I put the criteria...

Thank you the file was extremely helpful. I ran into an issue though trying to model off your file. I created the fields to type in the date, and redid my query to hold the date function, but now everytime I try to run the query I get an error that says: Circular reference caused by alias 'Sum...

would these have to be in seperate fields in the query or do I have to integrate them into the existing fields? So I would put this at the beginning of the profit query to set the value? After I do this, would I create a form and add combo boxes to make it more user friendly?

I have a query set up to add the total amount of sales made and the total amount of net paid for the product. I subtract both fields to create a profit field, but how do I sort it so I can choose the dates I want to see the profit? i.e. weekly profit, monthly profit, yearly profit? Thus far...

Is a macro what I should be working on? I have no clue how to create a macro so I guess I can start looking into it.

I am trying to design a customer/transaction database for my parent's office. I built up the file using office 2000's access and recently switched over to 2007. I'm still in the kinks of figuring out the new layout, but a problem that I can't seem to figure out is how to install a search...

well i tried playing around with a report but i couldn't figure out a way to combine the 2 queries so i decided i'd try using queries instead. i already have both queries, one with each seperate record and the other with the total sum but i don't know how to unite them together.

well i tried asking for help on this earlier, but i wasn't able to find any help so here is my problem. the sales - net = profit is fine but what i want to do is have a totals at the very bottem. everytime i try to do this, i can only get the totals to show and each individual record...