Search results

CJ, that syntax gives "Compile error: Expected bracketed expression", so I tried it with brackets instead of parentheses, and it likes the syntax, but when you run it, it gives a run-time error 3265 - Item not found in this collection. Any other suggestions?

Bart, I just posted a suggested solution to a similar issue, so I made a few tweaks to accomodate yours. Create a form with a button (cbResults). Then add the code to the form: Option Compare Database Option Explicit Dim db As Database Dim rsQuestions As Recordset Dim rsResults As Recordset...

Sounds like you don't need this reply, but I already had it worked out, so I'll send anyway. You probably already realized that in order to work with that data (in Access or Excel), the rows need to be transposed into fields. To accomplish this, create two tables: ImportData and Data. All...

Where do the Rank & Row values come from? Are they being entered manually in the txt file to keep the data grouped together, or is that the way it comes? Also, is the data import a one-time thing, or will new data be pulled in each week?

I have an application that is used to assign tasks to users. In some cases, proof of authorization is required, so the record includes a bound object frame control into which email messages can be dropped. When the assignee gets the task, it is read-only (AllowEdits = No). When they open and...

I tried what you are doing while having the file open in notepad. The Kill command successfully deleted the file whether or not I had it open, and it didn't matter if I had On Error code in effect because there was no error. Runtime Error 70 means "Permission Denied", so I would suggest...

And you said it couldn't be done! ;) Thanks. That gave me what I needed. I also set it up to look like the other controls by adding a "border" control. It is a textbox directly under the completion date textbox. It has a transparent border and a forecolor the same as the window, so it also is...

The 2nd DUE date will be given a value (or not) when the task is assigned by the system. I already have it set up as you suggested, with no borders and a background matching the form, so it only appears if it has a value. It's the 2nd COMPLETED date that I need the visibility optional, so they...

I have a form that shows assigned tasks, with a due date (locked) and a completed date that the user enters on completion. I'm trying to add a 2nd optional due date/completion date for certain tasks that have dual roles. I only want the 2nd dates to be visible if the 2nd due date contains a...

Thanks Bob. I had the query in there as the record source to pull in values for other purposes, but it wasn't needed for the actual record source, so I switched it back to the Users table and got my other values elsewhere. Strange that it worked in both 2003 and 2007 though. Thanks again.

I just thought I'd check & see if anyone has had a chance to try the attachment in 2010? I would appreciate it.

Thanks for the effort. I opened the one in the attachment above and it does not allow me to add, update, or delete records in the Users form.

I have attached a stripped down version of the db. I modified the Users form to have AllowEdits, AllowAdditions, and AllowDeletes to all = Yes, and I commented out the events code, but it still won't allow edits, deletions, or additions. I also imported my full db into a new one and that didn't...

Thank you all for your replies. Spikepel: I can neither add nor edit. I had originally thought I could edit. Gemma: There is no security in place for this db. Accessibility is controlled at the folder level. Bob: I did not convert it. It's still an mdb file. I will try your suggestions of...

Having heard no suggestions, I took a different approach and set the AllowEdits and AllowAdditions properties both to True in the form, rather than in the Load event. I am still unable to either add or edit records. I double-checked the record source value by pasting it into a query, and I was...

Sorry. The "New Record" button on the VCR control remains disabled in 2010. When I run it in 2003, it becomes enabled. I stepped through the debugger, and it does set the property to True, but I still can't add records.

We will be converting our employees from Office 2003 to 2010 over the next weeks, and I currently have both on my PC. In one of my applications, many of the forms set set various various property values in the Load event based on the user type. Setting the AllowAdditions property to true does...

Ok, now I'M reading with comprehension! ;) Open the form in design mode, right-click the command button that will do the export, and select Properties. In the Properties window, select the All tab. Note the button name. You may want to change it to something like cbExportToXLS. Also, you'll...

Ok, take a deep breath and read with comprehension :banghead: In the code for the button you are putting on the form for the users to click, have it hide the calculated fields you don't want to include, then have it do the export, then have it make the fields visible again. There are no...

I'm not sure what you mean by actioning the exports, but coding your command button to do what I suggested should work.