Recent content by williamlove

Cronk: Thanks for the idea. Before I try that, I'm studying the query that RJD (other site) gave me and trying to build a holding table from the seven sheets using DoCmd.TransferSpreadsheet as suggested by MarkK and others. Then, I might design an interface...a form or report, and use that line...

I was mainly looking for help on the query. Somebody made a query with my data (the data I put in the post) that did exactly what I wanted. They put it in an Access file which I have shared in this post in the attachment. My job now will be to use VBA to automate it. The other thing they...

This is a real problem I'm working. I have not simplified it much...it is a simple problem already. My question is at the bottom in bold. At the end of every week seven spreadsheets are provided each containing information about the number of alarms received each day. Three of the sheets are...

Yes it happens in others. Yes, any form filtered causes the problem (if opened using naviation, otherwise no problem). I searched and found some other people had this problem. Long story short it appears to be a bug. I have decided to not use this feature until they fix it. I'm disappointed...

This question is specifically about nuances of the Access 2010 Navigation Menu. That is important. I asked this question and got all kinds of answers but they overlooked that crucial aspect of my question. When I sort or filter records in a form that was opened (in Form View, not Design View)...

I noticed that somewhere along the line I no longer had to put the full reference to an object. For example, when I first coded my project five or six years ago (using Access XP or 2000) I had to do this: Application.Forms!frmContacts.Controls!imgContactPicture.Picture = sFullPath & "\" &...

Update: I got the combo box color to stay the same by changing the form's Alternate Back Color to white. I'm not sure if I might suffer any unintended consequences or not...any thoughts?

When I open my forms the combo boxes have a white interior and black text, which is the default and the way I'd like them to stay. But when I browse records, the combo box becomes transparent, by which I mean the interior color of the combo box becomes the same as the color of the form. I hate...

No, it is not, it is set to No.

The boundary between the bottom of the detail section and the top of the form footer keeps coming up in form view in a different place than where it is in design view. This covers up a couple of controls at the bottom of my detail section. I’ve played with form settings but have not figured out...

Thanks for directing me to this article!

Occasionally after editing multiple forms I hit save and after a long wait the save fails and I get a nasty message about File Sharing lock count exceeded. When this happens some or all of my forms and tables dissappear until I close Access and reopen it (and one horrible time my database was...

My app was done in Access 2000 and the file is still in that format but the problem I am about to describe appeared when I started using Access 2007. I get the same behavior when I rebuild enough of the app in a native 2007 file to test. I have two list boxes. On the left is one that I populate...

I use VBA Automation to add and modify rows in a table in an Access 2003 (MyData.mdb) database file. The VBA compliant program that writes to the database is called RSView. When I used Access 2003 I could have an instance of Access open and be working on the database and without it interfering...

I want to know if it is possible to get at the password needed to open the database in code. The reason: I have some Word docs with the same password. I want to open them. As it stands now I have to hard code the Word password.