Search results

Yeah, Rob. I think this will be the best way to solve the problem... thanks!!!

Great! I'll try that way then. Thanks a lot :D

Wayne, Thanks for the interest. The pop-up form will have names of people, like: John Mary Robert Grace Next to each name, a checkbox that the user will check if he wants to add one or more names to the record. Back to the previous form, I'd like to see in the text box those names that...

Ops! forgot the attachment... sorry! here it goes.

I'm attaching a screenshot of the report I'm talking about. I tried adding the Date field twice in the Sorting and Grouping box and also tried to add it to the Order By property of the report (as shown in my screenshot). Hope this clarifies things. thanks again!

I tried that but it's still not working. Any other ideas? thanks for the try :)

OK Access Gurus, this I think is a tough one. I would like my users to click on a button in my form. This will pop-up another form with some choices they can make through check-boxes. When they have finished selecting their choices and click on OK, a text box in the main form will show their...

I have a report running based on a query. In this query one of the fields is DATE. When running the query, I have no problems in getting the results I want and in sorting by date. However, when running the report grouped by month my dates are completely messed up without any proper sort order...

Thanks for your advice. I do agree that having everything in one table would make things easier... however there's another problem I just found out. Some invoices from UK may have values in dollars and some may have values in pounds! If I cannot differentiate one currency from another through...

I have a database with two tables, one that stores invoices for US customers and one that stores invoices for UK customers. Both tables have the same fields (invoice #, customer name, item, value, etc...) however the US table keeps values in dollars and the UK table keeps values in pounds. I...

This is probably a basic and stupid question, but here it goes. Can I have in a currency field in my table with values in both dollars and pounds? Or maybe the real question is: can I somehow identify if a currency value is in pounds or dollars? Thanks!

bjackson, that's a good idea however I also tried it and it didn't work... THEN, I started thinking about my startup options and I found out that if the "Allow built-in toolbars" option was unchecked my code wouldn't work. I activated this option and it all started to work!!! I don't know if...

Hi! I've read lots of threads on how to hide and show toolbars and tried everything possible however I am still having problems with my application. Here's what's happening. I have security in place so every user has one userID and passwd. There's a startup form in place that checks which user...

That is exactly what I was looking for. Great code! Thanks for sharing !!! :)

Great! I'll take a look at the sample reports in the Solutions database. Thanks for the link :)

I don't want users to go to Excel to see the report, my intent is to have the report ready so anyone can just click a button in Access and bring it up. I was thinking having something that would give me the following: ........... 2002.....2003 ----------------------------- Jan...

I need to create a report that will compare two different years. For example, I have a table containing sales data for 2002 and 2003 and I want to create a monthly comparison (total sales Jan/02 vs. total sales Jan/03). What is the best (and easiest) way to do that? Your advice is greatly...

That's a great resource! I'll check what they say and see if it works... will post my results in this thread. thanks!

Humm... I tried your code but it doesn't seem to work. I'm getting an error message "Compile error: Sub or Function not defined". Any ideas? thanks!

I've got a database where different forms show up depending on the user who logged in by using the CurrentUser function. Is there a way to identify the group to which the user belongs? I couldn't find any function to be used in a macro or event that will give me that value... thanks!:)