Search results

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.

Yes Adam someone at that site gave me the solution Private Sub cmdShowRelationships_Click() DoCmd.RunCommand acCmdRelationships DoCmd.RunCommand acCmdShowAllRelationships End Sub But I must confess I still don't understand why it works with the second command, I don't see why my original line...

I tried creating a means for a user to look at the database relationships using Private Sub cmdShowRelationships_Click() DoCmd.RunCommand acCmdShowAllRelationships End Sub I get runtime error 2046: "The command or action ShowAllRelationships isn't available now." I'd appreciate tips on how to...

I am trying to figure out when it will be important for an Access developer to embrace .net. I guess that is the same as asking when will .net code be mandatory or at least highly recommended for Access? I use Office 2003 and my understanding is that right now, except for managed add-ins, you...

George I fixed the problem by doing the code below; I don't fully understand why I had to do that but it works and I'm grateful. Thanks for your time. If you know why this works tell me.... Dim sFullName As String sFullName = sFullDigits & ") " &...

George, I followed your suggestion, here is the modified code: Private Sub ScatterFields(objCD As CD) ' Copy values from a CD object out to the form's controls. Dim iTrackCount As Integer Dim iTrackIndex As Integer Dim sFullDigits As String If objCD.Load() Then Call...