Search results

Sorry Janeyg. I misread your 1st post. When I export a form, it only exports visible fields, so my suggestion is to have your code set the Visible property to No on the fields you don't want, then do the export, then set them back to Yes.

Create a second query that uses the first one as the datasource but does not include the calculated fields, and use the second query for your export.

To copy an Outlook message into an OLE Object field, you have to first copy & paste it to the desktop, then copy it from the desktop and paste it into the database field. No other way around it that I've found.

I have a field called NoteMsg with a datatype of OLE Object. On the form, the field appears in a Bound Object Frame. MS Outlook messages are copied and pasted into the field to provide supervisor approval for projects. On the form where the messages can be opened and read, the Allow Edits, Allow...

I finally got it to work with trial & error by adding a me.requery after setting the combobox value. I have no idea why it's needed for 2010 when it wasn't for 2003, and apparently no one else did either. Thanks for your ideas anyway.

That might explain it if it was one or two users having the problem, but the problem is machine-based, not user-based. It works for me personally on Access 2003 machines but not on 2010, and is consistant in the same way for other users. I have stepped through the debugger on both machines, and...

CurrentUsername isn't a function. It's a global string variable, hence the SetUserVariables functions. As said earlier, the function's working fine and producing the correct result, which shows up in lbAssignee.value in the debugger. It's just not selected when the form appears. We have all...

Thanks for your replies. I guess I'm an old-timer. From my early days, I've always referred to combo boxes as list boxes (I never use actual list boxes), so I use lb as the prefix, and lbl for labels. Yes, it's a combo box. I can't use "TEXT" because that's not an item in the lbAssignee data...

I have a form with code in the Open event that selects the current username as the default value in a combo box from a list of usernames. It's an Access 2003 database, and it works fine for 2003 users, but for 2007/2010 users the selection is blank. In debugger, it selects the value correctly...

I am exporting a query to a spreadsheet, and the resulting worksheet has tic marks at the beginning of each cell, including the headings, with the exception of one column that has a date. Is there any way to get rid of these? I tried experimenting with changing the AcSpreadSheetType from the...

Yea, apparently that can't be done. I'll create a function to concatenate the names instead of using a query. Thanks.

Yes, EmpNum is pk.

Through trial-and-error, and attempts to eliminate suspects, I've concluded that there is some other problem here. I reduced the queries to the following and it still won't allow updates. I also created new queries from scratch and compacted & repaired the db with no better results. It still...

I can understand that I wouldn't be able to update the name, but the rest of the fields are locked as well. Is it always all-or-nothing with queries?

I have an Employees table and a couple of queries, qryEmpNames and qryEmployees. qryEmpNames concatenates the first and last names into a Name field, and qryEmployees links the Employees table with qryEmpNames, linked by employee ID. Why would the data in qryEmployees not be updateable? I've...

I'm developing a db that will have the same scenario. I haven't tried it with multiple users yet, but as soon as I get it finished, I was planning to split the tables out to a separate 2003 db, then have separate front-ends -- one 2003 and the other converted to 2010. If you get a chance to try...

I'm developing a work order system that creates assignments for IT users to complete for various employees. Each assignment will have notes attached. The issue I'm having relates to three of the tables. WOrders (pk=WONum) has a one-to-many relationship with Assignments, and Assignments...

My form has a toggle button, tglAutoRefresh, that works with the timer event to to automatically requery the form data every 60 seconds. The code includes a DoCmd.FindRecord to re-select the record they were on. It works perfectly. However, I also want the button to serve as an immediate...

I have a master form that opens a synchronized slave form in its Open event, and tries to close it in the Close event, but it won't close. It breezes past the Close command without an error, but nothing happens. The slave is a popup, non-modal form, but I've tried it both ways. Any...

I would have never thought of that, but it works perfectly. Thanks!