Activity Stream

I'm not familiar with Access by any means and admit I am a noob. What my colleagues and I need is this document converted over to Access but we...

Hi all, DB attached. On Form (frmOnLineAccess) when I enter a new name into field Search Institutions, it fire a Not in List, which it is suposed...

Hi all, Still struggling with these DLookups....Sorry but have tried this 100 different ways What I am atttempting to do is: LookUp the...

It is real common to use me.refresh in a sub of the form. I need to use refresh in function. Instructions says to use form.refresh. But when I put...

I created a report with several subreports based on the following query: SELECT tblSegment., tblSegment., tblSegment.Descr, ...

Hi all, Data Base Attached, Opens to frmZip, enter Zipcode and Tab. If Zip does not exist or has more then one, it will open another form. If does...

When opening the VBA editor, Access opens some module code windows. Which windows are opened doesn't seem to follow any rhyme or reason except...

I have eliminated all fields on my tblCalender that were also on another table. This reduced it from 15 fields to 3. Yes 3. The other 12 fields...

Please forgive me I am feeling a bit fragile. I "improved" a bit of code mid August and went away on holiday on the 31st. Next day and irate...

My Access database has entered a confusing state, where some records have suddenly become non-updatable, despite no recent structural changes....

I have a form with RecordSource "tblInvNew", which is empty and is identical in structure to table "tblInv". All of the controls in the form, where...

I have a problem I can't seem to figure out. I have a form with a bunch of search filters to help users find records. They can also create new...

Hello. I'm looking for your collective wisdom, if you can relate to my scenario. The following situation: - Windows Server 2025 64-bit...

Private Sub Form_Open(Cancel As Integer) Me.Filter = "" Me.FilterOn = False Me!CountryCbo = Null Me!VarietyCbo = Null End Sub ...

I am trying to create an update query to add data from 3 fields of one table into the fields of a second table. I copied a formula from the...

Hello all! This is my first post here. I'm new to creating access database and having some issues. I was given the task of taking the database...

I have a very basic access database. The table that contains all the data has 221 records, all listed alphabetically. The form that reads and...

I am having trouble learning queries. The sub following runs, but it don't update the table. Please help. #Sub modQue_addNewLocation() ' ...

Hi all, I have textbox1 that has a drop down selection of (Station, Tunnel, MEP). Now, I want that when I select “Station”, my textbox2 will have a...

The sub works good as long as there are records to locate. But when there isn't, I get a No Current Record error. The internet says the cure is to...

On a continuous form, click one of the bound fields to effectively be the same as though having clicked on the record selector. I want to click on...

Hi I have what I feel is a very simple task and that is to filter the SimilarTo ComboBox so that it only shows data related to the Customer ComboBox....

I've created a form based on a table. Everything works fine. Now I am adding a text field to the table and form, I create a text field on the form...

Hi, looking for a way to recall a record for editing by using a filtered combobox. I have had this working without a filter on the unbound Combo26....

Hi, been struggling with this for a while and would really appreciate some help. I have a table called CableParts. I use the form frmAddNewParts...

Hi i have 2 tables i called " internal works order part2" and the other one called " order details " i have noticed that the feild called...

I'm in the middle of a QBE and when I start entering a Criteria I get the following message: The expression you entered contain invalid syntax and...

I'm a newbie, so please forgive me if I sound confused... We have migrated from our old Win 10 PC to a new PC running Win 11. The old PC was...

We’ve stopped using Cloudflare because it was causing login issues and other inconveniences for our members. Everything should work as usual now —...

Thought this would be simple but I can't seem to find an answer. I want to count the number of unique values in a field and show that number on a...