Search results

namliam, Thanks for your reply, but this isthe same I've tried out. My main goal here is to see what permission the current user has for a form using VBA. I don't understand the container/document properly, because I'm interested in a spesific form in the container/document object.

Dwight, Combos are great and sometimes much easier to handle, but there's no 'grey area' - meaning either they are limited to the list or they not. You have to limit it to the list, otherwise your users can add new ones, and then you face the risk of getting more than one item in the list that...

Put the appropriate number of buttons on the form you want. In the OnClick event of each button you put: Me.YourTextBoxNameHere="Your Message Here" Set the Caption if the button as desired. Do this for all the buttons. Take into consideration, that if a secons button is clicked when running...

namliam I only use thre 'users' instead of groups, because there are many people that use the same computer, and 'who does what' is not important. One 'user' has all rights as an admin, and all users who has admin rights log onto the db with the same username with the samw password. This works...

Yes, thats what I use today. The downside to this is that any changes made to the workgroup file must also be done in my forms VBA code. I want to avoid this. What's the other way(s)? Thanks for your reply ColinEssex

Hi, I want to check what permissions a user logged on my db has. I've checked out the AllPermissions and Permissions properties. I would like to see if the user has permission to click a button or something else in a spesific form. Can this be done in VBA, and if so, how? Thanks in advance...

Thank you both for your answer. Great idea to use a local temporary table, but I'll most certainly want to use that when I need a more permanent place tp put things. Burt, I looked up the filter property earlier, but where I looked it did not say it applied to recordset objects. I've looked a...

Thanks for your fast reply Mile-O-Phile! The reason is that I want this process to go as fast as possible. Each time the query runs, the data must be fetched from the backend. If I instead run the query once, returning all data and then get the ones I need from the recordset variable instead...

Hi, I'm running a procedure where I'm reading all records from a query into a VBA recordset variable. How can I create a new recordset which is filtered by a criteria, based on the VBA recordset variable? Thanks for any help in advance Regards Gerhard

Hi! I have an Access module that transfers data to an Excel spreadsheet in a workbook. There are one workbook for each month. Today they have created all the workbooks for this year. So when they start transfering data to Excel, overwriting the existing workbooks, I get a problem since they are...

Hi, I'm transfering records from Acces to Excel (using the Excel 9.0 library - not TransferSpreadsheet Method). The filename of the workbook is construv\cted based on month and year, for instance Feb2003.xls If the file don't exist, I'd like it to be created, but without the user being able to...

Thanks for the help Ken. Found other interesting stuff there as well. Regards Gerhard

Hi! This is more of an excel question, but since I'm transfering data from Access, I'll try it here. The scenario is that when I press a button, the records for a selected month/year is transfered to excel. This works fine. What I want to know is; if it's possible (from Access) to see if the...

Excellent! Thanks again! Regards Gerhard

Sorry for not being clear on this one. I know that when you run a query, it returns a recordset. I want to have the recordset returned by a query available in a recordset variable in VBA. I searched the help files, and came across the OpenRecordset method. Am I at the right track here or what...

Can anyone please help me on how I create a recordset from a query in VBA? Thanks in advance Gerhard

mark, It's the requery in the After update event which causes cascading updates. Try using Me.listbox206.Refresh instead of Me.listbox206.Requery. Regards Gerhard

Sounds pretty normal EXCEPT what happens when trying to reopen the DB file once again. The ldb file gets created but no db window or anything else? (see in the task manager what's running). Do you use objects which is 'hidden' ? using Echo? If you're the only user, try open the db in Exclusive...

Thanks for the reply Mile-O-Phile. It works as you say, but only if I put some text/charachter between the quotes. I'm trying to use a single double qoute sign (to use as a repeat symbol for the row above in a report) so I came to think of the ascii table and used strA=Chr(34) to get the "...

Hi, I can't get my head around this today, so any assistance is most welcome. How do I use a double quote sign in a VBA variable, so when the variable is passed to a textbox, it shows up as one? eg: strA= ? Me.MyControl=strA MyControl show " Regards Gerhard