Recent content by Dunnopat

Thanks for trying. I got back the problem was with user rights to the network folder. Some big company is supposed to handle adding and deleting users.... bah... Maybe this helps someone else who runs into the same problem.

Problem with database (2950) [SOLVED] Access 2007 Windows XP (updated) My database gives 2950 error. http://support.microsoft.com/kb/931407 is not a solution. Let me explain: There is local file X that contains forms etc. There is a file in a network drive that contains the data. The files...

Thanks a lot. It was that simple but somehow I just couldn't get it. It seems that my mind got much clearer too. I fixed some random problems that annoyed me in the past. I never figured out how to fix them before.

as long as LASLEFT is other than 0, the row must be shown. Out of those where LASLEFT is 0, the rows where REMAINING is more than 0 AND it's not expired, are shown. Underlined data needs to be shown Bold data is shown if I use that filter. (unless I understood wrong) expired, lasleft 1...

Doesn't that filter show only the data I don't want to show? Or does it hide the data that is either ([EXPIREDDATE]< Date() AND [LASLEFT] = 0) or ([REMAINING] = 0 AND [LASLEFT]=0)"

Edit: Sorry, can't open it. Not allowed. It's hard to explain my situation too when I can't really tell anything. Even the names of the fields are changed. I was wondering, could I do the following: I make a query that selects those rows that I don't want to see in the form. One of the fields...

But the data source can't be changed. There needs to be an option to view nonfiltered data. There are also many buttons that filter the data in some way. If I "filter" the data in data source, then the data that is left out can't be accesses with the form.

The idea is that when the form is loaded, some rows are filtered out. The rows are ones where EXPIREDATE is before current day and LASLEFT is 0 AND rows where REMAINING is 0 and and LASLEFT is 0. It's been a while since I last did much with access. Can anyone give me a hint? I can make it...

Hello I have a split form. Three columns contain currency data. First one, PRICE has different set values, for example 500€. Second one is calculated, PRICE*fieldA in the form. Third one is also calculated, PRICE*fieldB. I wanted to create totals for those two last columns. However, access...

Access 2007 I got a split form. Basically, upper part contains buttons and the lower part is a table (from a query the form is based on). The table can be filtered (by clicking next to the column title, default access function) and I want to create a button that opens a graph/chart based on the...

Hello. Forms!YourFormName.Requery worked well. I wonder why macro didn't work. However, unfortunately, I have no idea what you mean by: "You will need to make a query to collect all the data you wish to show on your report, in the criteria for your query under the check box use the...

Hello Two questions: 1. I have a form with a table on bottom. On the table, each row has a checkbox. Using it will save it to table the form is based on. There is also a report button. I want the report show only the data that have checkbox = true in the form. It is easy to make it show those...

Ah, I finally got to respond. I finally got it to work. I had to modify it a bit. It's not exactly pretty but it works and the user won't notice anything weird. Thanks a lot for help. It is all thanks to you that I got it to work. Anyway, I must have been very tired when I posted that first post.

Hello. Thanks for trying to help. I have the same problem with my db that I have with that one. Searching and going to the found record works. When it's not found.... thats when the problems come. It adds the new SSN. However, it goes to a new record, while the form stays in the empty one. If...

I couldn't get it to work. Does it matter that the SSN field contains text? I'm having hard time because access I use is in other language. I right clicked the box and added modified code to it. Nothing happens. After setting limit to list to yes, it just says that the value is not found.