Search results

"Moveable" property is set to "yes."

Not sure why it isn't working, but AutoCenter = Yes is not doing the trick.

I am using Access 2007 and cannot get a form to center, even after trying the following: 1. Overlapping windows is selected 2. Form Properties AutoCenter: Yes AutoResize: Yes 3. In the "OnLoad" Event, tried: DoCmd.Restore Me.Move 0,0,5000,5000 Regardless, it always opens in the bottom left...

Found the answer and went in a totally different direction and used tab control values. I tried placing this code under "on click" for the individual tabs, but that did not work. Instead, I placed this code under "on change" for the entire tab sheet (TabCtl20). If Me.TabCtl20.Value = 0 Then...

Hello. I have a form (Frm1) with a subform (Subfrm1). Both Frm1 and Subfrm1 have tabs. When I select a tab in the subform, I would like to write VBA code to select a specific tab on the main form. So, In Frm1, I have TabCtl10 with Page11 and Page12. In Subfrm1, I have TabCtl20 with Page21...

Apparently, according to the Microsoft website, this is by design. I have read several ideas from several websites and have found only the following procedure to work: Change all fields to text in the table before exporting. When you go through the export procedure in Access, the data will...

No. There is no error in the code, and I'm assuming code isn't the problem since it works well for others. I'm assuming it is some security setting on my computer or in Outlook. I've tried the suggestion of turning Out of Office on, rebooting, and turning it back off; but it did not work.

Did not work.

I'm not sure if that's the right course of action, since it works perfectly for other users. I didn't know if there was some kind of security setting on my computer that is preventing the email from being sent, even though I select "allow" when the window appears warning me that I am about to...

When a button is clicked in a form that adds a new record, an email is sent to 3 users containing the record information. The email format is set up in VBA. This worked great before we converted to Office 2007. Now, it seems to work for everyone but me. The new record is saved, but the email...

I'm not sure if this is what you were implying, but this works: You can look up "create a multiple-column report" in the help files, and it will give you step by step instructions. In summary, create a report, go to design view, go to File -> Page Setup, and select the "columns" tab. You can...

Hello: I would like to print up to 8 records across a page, instead of down. I've tried a Crosstab query, but I don't think that is going to work because I'm not doing any type of math on the records and I want multiple row headings. I would like the report to look like the below, which...

ok...FINALLY resolved. The database was looking for the fxsocm.dll file (inlcuded in Windows SP2). The file was located in c:\windows\system32\setup folder. Only personnel with computer admin rights are able to see that folder, which explains why there is a missing link when users w/o...

Ok. We've discovered an interesting twist to this today. These problems only arise for users that do not have admin rights to the computer. If a user has admin rights, the database works just fine. The 2 errors we get for those without user rights: 1. When we start the database, it says we...

Yes, I've compiled after rechecking the references.

I have a replicated database in Access 2003 w/ SP2. A coworker in another location controls the master database. We have the following references selected in VBA (listed in order): VBA, Microsoft Access 11.0 Object Library, OLE Automation, Microsoft DAO 3.6 Object Library, Microsoft ADO 2.8...

No changes need to be made to what I printed in my last post. The only change I made from raskew's code is how I called the function. Instead of inserting the table name, I inserted the query name in the first part of the expression. I want Expr2 in Query1 to be the median of Expr1 in Query1...

No changes need to be made to what I printed in my last post. The only change I made from raskew's code is how I called the function. Instead of inserting the table name, I inserted the query name in the first part of the expression. I want Expr2 in Query1 to be the median of Expr1 in Query1...

No changes need to be made to what I printed in my last post. The only change I made from raskew's code is how I called the function. Instead of inserting the table name, I inserted the query name in the first part of the expression. I want Expr2 in Query1 to be the median of Expr1 in Query1...

Stink...ok, thanks.