Search results

ghudson, Thanks for alerting me of the shortcomings of my db's setup. Is there any way to remedy the problem? Thanks.

Trevor, The code worked perfect! I appreciate your help. I'm still curious about the questions I asked in my previous post and have one more thing to add. I need a way of not displaying the tables. I've tried splitting the db and requiring a password for the back end, but then the...

Trevor, Thanks for the update. I'll try it and let you know. (Also, read below. I use forms as Mr. B mentioned so I'm not sure if that will affect the code...) In the meantime, I have another question. I understand the concept of an administrative area but I'm not sure if there's special...

Trevor, Thanks for the response. I have a comment and a question. When I copy-pasted the code you gave, the 'if inputbox...' line was colored red. I tried to space it differently, then to put it back exactly as you had it, but every time a box poped up that said 'Compile error:/Expected...

Hello, I'm wondering if there's some way I can require a password to edit a table in Access 07. I know how to require one for the whole db. But I want this db open to everyone for searching and viewing, while restricting access to edit the tables. Hence the password only for tables. Is it...

That's not quite the problem. I do keep the paper receipts. But I also enter the date manually, so it doesn't matter when I enter them. I'll explain a little more about the db. I have a 'TDate' field for the transaction date, which I enter manually. Then I have a 'Month' field to enter the...

Hello, I wasn't sure exactly where the problem is occurring so I'm not sure where to post my question; hence the general section. I've designed a sort of financial database for my checkbook-keeping. I'm not the most Access-savvy person so explaining how I've designed it could be complex and...

Worked like a charm! Thanks once again for all your help.

I've been toying around some more and everything works great. Thanks again - I appreciate the help. As for my two questions the other day: I had the 'Number' field as Number/Byte. But I've since then tried to change it to every category under Number with no results. I finally had to change...

Sorry I'm delayed in response. I hope you had an enjoyable Memorial Day weekend. I'm satisfied with what your advice has accomplished with my form. Thank you so much. But since I 'have you here' I want to ask another question (I had two but forgot the second one right now). Now that I can...

pbaldy: Thanks for the clarification. After fixing the sql I'm pretty sure I got it working now. I want to have more time to run further tests and make sure that it's in fact working, that I've covered all the bases I want to. But I just wanted to give you an initial confirmation. I'll post...

pbaldy: I just can't quite figure out how to properly incorporate that first link you posted. Whenever I change the code for the combobox, a message pops up saying 'The number of columns in the two selected tables or queries of a union query do not match'. If all I have is one column on the...

What a coincidence: as I was looking for a solution I came across that first article-link you posted. Unfortunately when I tried it it didn't work. When I tried the second one (for queries) I thought it worked at first. But alas on closer inspection it didn't, especially when I tried to place...

Hello, I have a form which has three comboboxes: Account, Month, and Year. Currently I'm limited to one account's records for one month in one year. However I'd like to add an 'All' option in each of the comboboxes in order to be able to select multiple records. (For example, I want to...

It worked. I don't know how I hadn't tried that myself (well, I did but in a roundabout way). Thanks!

Hello, I'm having trouble getting results from a form that I want to ask for the month. I have a table with a date field formatted dd/mm/yyyy and a query which pulls records including the dates. For my form, I'd like it to have a combobox with a dropdown of each month so that I can view all...

Ok then. Since I was able to get the result I was (ultimately) looking for, I have to thank you for the help.

Ok I tinkered. I was able to create a command button and link things up so that the account I selected on the form was filtered by the query and displayed in the report. However I just want to confirm that there's no way I can get a drop down list in my query parameter rather than an empty...

I thought I'd tried that earlier but to be sure I changed the criteria as you indicated above. Again no result. Like I said before though, I'm not sure how to make the form use the query to find the data and display it on a report. I'll try to tinker around but I have limited knowledge, so if...

Your response wasn't necessarily poorly worded - more my understanding of this process was misguided. Your explanation makes perfect sense but I still wouldn't know how to design the process. I'm attaching it for you. (I hope I did it right. If my zipping doesn't work let me know and I'll post...