Search results

Yes, I would like to leave the users the capability of composing their own queries (via the Query Wizard) but keep them out of the stuff in the ribbon that can modify the database. The .accdr extension suppresses the ribbon except for File/Print & Exit but also unfortunately suppresses...

I have just discovered one can "lock" (if that's the correct term) a database, such that users cannot modify it, by changing the file extension .accdb to .accdr. This works well but, I cannot figure out how to let users still get access (so to speak) to the Query Wizard. The closest macro...

Cowtown :)

Bingo Wayne! Yes, the objects were inside a close-by rectangle (which was added after the dbase was ported to 2010). Removing the rectangle made it work and vice-versa when the rectangle was replaced. Bringing the objects forward then made it work again. Thanks much (from another Crazy Canuck).

Hey Pat, I'm not sure what the statements are for (are they VB code and if so, what do with it?). Anyhow, tried exporting to text by right click (on the objects menu on LHS of screen)/form/export/text file/windows (default) and I get a "There isn't enough memory to perform this...

Thanks for the suggestion Pat but I tried that and no change - original controls still don't work.

Thanks much Isskint - who knew it would be so easy :D

I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not...

No, they aren't part of an option group. Only other thing I can think of is that the database was converted from Access/Office 97 to 2010. The conversion caused a couple of issues but they are resolved and AFAIK are unrelated. Addendum: Tried creating a new database (in 2010) with ControlTip...

Just tried out ControlTip Text on some command and toggle buttons. The text pops up on some but not on others and I cannot determine what the difference is (the properties are essentially the same except for name, caption etc). What buttons work and what do not seems random but if I copy/paste a...

Tried a couple of things: Created an entirely new database and added a "Duplicate Record" macro within a command button. Ran the macro and got the same error message (".....Paste isn't available now") as above. Reran the macro in single step and it worked! Reran the same macro in my original...

Thank you again Alan for the help. What I've come up with to append-paste a record copy is split the select/copy/append-paste SendKey macro (which doesn't work because the copy part deselects the record for some reason) into three steps; the first selects the current record, the user then types...

I'm M/L familiar with the topic but my application is more a "flat" (if that's the term) file than anything else (it doesn't have/need any keys). The app is "patient" admission data for a wildlife rescue organization. There are many fields required to store the applicable data such as contact...

Thanks Alan. Your understanding of the problem is correct and, while I know little about VB programming, I think I can follow what the code does. Trouble is though, rather than four fields in the record, I have 102 which will result in a lot of code. I'm thinking there must be an easier way -...

One of the actions available with the Command Button Wizard is "Duplicate Record" (which I gather is to copy the current record and append it as a new record). Trouble is, it results in a "The command or action 'Paste' isn't available now" error message. I've looked at the Macro the action...

I have two forms each connected to the same table and am having difficulties getting calculated fields in the second form updated to reflect data changes entered in the first form. Both forms are displayed by a command button macro on the other form (using the "OpenForm" action in the macros)...

Thanks Pat for the help. I know nothing about QBE (I'm a newbie as you may have guessed) but maybe now's a good time to learn something about it. With regard to SendKeys though, I've narrowed the problem down to the Copy command (following record Select) which doesn't work for some reason if...

OK, I've found a keystroke sequence for copy/append the record and it works properly when performed manually. The key sequence is: %HWH%HHL%HC%HVN%HWF where: %H - got to Home tab (in form view) W - view H - datasheet view (cursor at record displayed in form view) %H - home tab H - select L...

I have an Access 97 database in which I was able to compose a SendKeys macro to copy the record currently being displayed in a form and append it to create a duplicate record (this being done in Table View). I used the Select Record and Paste Append commands under the Edit tab to do this but...