Search results

Sorry, I am new to this. The date field is set for Date, and it works for the current month bring in everything we worked on. But when I go to past months, it leaves a lot of jobs out, when I know that the data is there. I have other reports that I use the data to bring in the data I need and...

It is just the Date, ex start date: 1/1/2015, and a end date: 1/31/2015. I am asking it bring those jobs that we worked on during those date. This works for my other queries that I use for reports and those show up for those dates. But for this query is does not was to work right. Thank...

Not understand this problem. I am putting a query that pulls from data from the same table. I have a date range so that I can choose a month period. Now, when I put in say the current month, everything works find. It gives me all the items that we had worked on for that month. Now here...

Thank you.

Quick question. How does one search on this site for past post that might be related. I do not see a search to search. Thank you. Tony

Good Afternoon everyone. I am having trouble figuring out how to take a database that I did for my mom, that is accdb to make it accdr, and to also put that with runtime. For some reason I cannot get the accdb to go to accdr. Also not sure how to work with runtime. Is that just something...

Thank you so much CJ_London, that was very helpful. I know I should break down and learn C# and create the database from scratch, but I really like Access. Thank you again. Tony

Thank you for responding. So with this runtime, will this allow the person who does not have access use my database. Also where do I get this runtime, and how do I work with it. I am trying to create a database for my mother using access, but she does not have access, I though I read...

If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it...

Hey figured it out. I found that there was an empty record will no data that was holding it up. Once I took that out, it works again. Thank you for your help. Tony

I would send the database, but it has business personal information on. ;( The error message reads "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too may complicated elements. Try simplifying the expression by...

I have this weird problem, I have my forms set up so that I can put a date range in the boxes, a start data in one, and the end date in the other. This works great and have been using this for a couple of months now. Here is the weird part. For some reason when I wanted the date range Feb 1...

Are DLOOKUp hard to do, never done one before.

Hello This might be a hard one. Is there a way to have say five different reports that give out information and at the bottom the totals. I would like to take each of those separate reports to create one report with just the totals. Is this possible? Tony

Hi Paul Thank you, thank you. It worked like a charm. Thank you again. Tony

Hi Paul I just use the button options that was offer in the design. When the popup comes up, it allow the user to chose any report they need to see. When the button is pressed, it brings up the correct form. But the popup does not go away, I had to put a close button, to close it. I...

Paul Not sure how to do the coding behind the button to close the popup form. Tony

CJ_London What do you mean query grid? And how would I fix it? Tony

CJ_London Hey that works great but I have a question. When I bring up the query everything comes in its number order. Looks great. When I turn that into a data, it puts them in a different order, how can I make sure that the report will show the data just like what is in my query...

CJ_London Hey, got to work, forgot that I had to refresh. That is really cool. You are very smart. How are you with PopUp Forms? I put a question on the Forum but the guy is not very helpful. Thanks again for this one. :)