Search results

Hello, I have created a split Access 2007 database that is currently used by a few people in a mid-size company who are running it in Runtime. Because small changes are always being made to the front end, I have found it is necessary to post new releases fairly frequently. Several of my users...

Several years ago, I started creating a database at work with no previous experience. As time went by, my skill level has increased dramatically and it has taken years of experience and hard work to get where I am now. In this time, I learned everything I could about table structure, data...

Hello, I am using the following code I found to hide and show my subforms as the tab control pages are changed: Private Sub TabControlMain_Change() 'Set the source object for the subforms as the tab control pages change. This should help to decrease load times on open Dim pgn As...

Hello, I am experiencing an issue with my forms that seems to have cropped up out of nowhere: the forms are not opening in modal/dialog mode when they should be. The forms' pop-up and modal properties are set to "yes" The code specifies to open Dialog so, for example: DoCmd.OpenForm...

All of the sudden, when I go to export my reports to Excel I get an output error (see pic). I have done this exact same thing dozens of times in the past without issue. I tried repairing Access but it did not work. There is no code being used to output the reports. Has anyone ever seen...

We all know the rule that calculated fields should not be stored in tables but is it ever ok to tweak this rule? Please hear me out... My database is for an international architectural firm. The US projects use the imperial system (feet) but every other country uses the metric system. These...

I have a form that is opened as hidden when my startup form loads. Data gets entered into it from other forms so whenever I switch records the hidden form needs to be opened to the matching record. To accomplish this, I have been using the DoCmd.OpenForm in the OnCurrent event with the WHERE...

Hello, All of my main forms contain multiple tabs and some of them take a long time to load. Would someone please explain the concept of lazy loading? Do you think it is a better way? Does it have its pitfalls? Some practical guidelines about how it is executed would also be much...

Hello, I have been trying to write some code to be used when my forms close. The code checks if other forms are loaded and, if not, opens the switchboard. My problem is that the switchboard is opening all the time. I am hoping it will be an easy fix for someone with more experience. Here...

Hello I am using the following code to filter my form with a search box: Me.RecordSource = "qryCompanies" Me.Filter = "CompanyName Like '*" & Me.SearchTxt & "*' Or webpage Like '*" & Me.SearchTxt & "*' Or PriorName Like '*" & Me.SearchTxt & "*'" Me.FilterOn = True 'Show message box if no...

Is this possible? How?

Hello, I have a subform that has a junction table for its record source. The junction table has required fields, one of which is a field called Status. This is nothing unusual as all of my junction tables have required fields and I have never had a problem like this before. However, with this...

Hello I am trying to use this code to filter a continuous subform based on two criteria but getting a data type mismatch error. It works fine if I filter by just one or another. Perhaps it is not possible:confused: Or, does someone know a way? Dim intSpouseEntityID As Integer...

Here is my code: Private Sub btnRemoveSpouse_Click() Dim PriorValue As Integer PriorValue = Me.Spouse.OldValue Dim dbs As dao.Database Set dbs = CurrentDb dbs.Execute _ "UPDATE tblContacts " & _ "SET Spouse = " & Me.ContactID & " " & _ "WHERE ContactID = " & PriorValue Me.Spouse =...

I am a little bit lost here. I have a SpouseID field in my Contacts table to link spouses. When a spouse is selected in one contact's record, I want to be able to automatically update the other contact's SpouseID control. I have created a calculated control called txtSpouseID that uses...

I would like to be able to clear a combobox selection with code but nothing I have tried is working. I have searched for the answer and tried numerous suggestions and still nothing works. So I turn here... Most recently I have tried this: Me.cboCompanies.ListIndex = -1 To no avail. The...

Why can't I ever get these to work properly? I want to use them to ignore null fields so that I won't get the punctuation but it isn't working. Here is what I have but the commas still show up: =IIf([Status]=1,(+[MailBoxOrPOBox]) & (+", "+([CompanyLocID].[Column](2))) & (+"...

Hello, My database has a button that saves a contact as an Outlook contact. This is a standard button that came with a template that I used when I was getting started several years ago. When clicked it runs a macro (RunCommand > SaveAsOutlookContact). It is a great feature as is but it is...

Hello, Could someone please help me out by giving me the code to close all open objects? Using just DoCmd.Close only closes the active object. I have been specifying everything individually but this is not practical as my database grows. Thank you!!

Hello, I am currently using a Macro to assign auto keys. However, since my users are using Runtime, I am finding the program crashes when one attempts to use an auto key when it cannot be used. I have tried to solve this by using the OnError action to make the macro fail and abort but it is...