Search results

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...

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...

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...

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...

Hello, I'm trying to create a query parameter which provides a drop down list rather than a blank form to manually enter the parameter. The main reason is to avoid mistakes in typing since I will not be the only person using this db. I've searched and searched the net for a solution but just...

I'm trying to sum a bunch of account fields (it's a financial db) in a report to see if they balance. I used the formula '=Sum([Balance])' in a text box in the Report Footer but unfortunately the summed value displayed is incorrect. When I visually added the numbers in the print preview I get...

I've been trying to create a running total in a query but can't seem to figure it out. I checked multiple sites on the web with no luck. They directed me to use one of two routes: SLQ or the DSum() function. No matter which one I try to use this message pops up: Microsoft Office Access has...