Activity Stream - Microsoft Access Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums

09-15-2025, 07:13 AM

jerikson started a thread Need help converting Excel to Access and retaining same data in Access

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...

22 replies | 9108 view(s)

09-14-2025, 08:59 AM

d9pierce1 started a thread

Adding an ID in Website on Form? in Programming

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...

9 replies | 5813 view(s)

09-27-2025, 05:40 AM

d9pierce1 started a thread

DLookup Help in Programming

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

16 replies | 3966 view(s)

09-10-2025, 12:02 PM

lawdy started a thread

How to use refresh in a module in Programming

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...

12 replies | 4126 view(s)

09-17-2025, 01:54 PM

IndianaITGuy started a thread

Trying to create a separate pdf file for every record displayed in a Report in Modules

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

4 replies | 4966 view(s)

09-13-2025, 06:45 AM

d9pierce1 started a thread

Data MisMatch error on code? in Programming

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...

10 replies | 4117 view(s)

09-21-2025, 06:38 PM

jhg6308 started a thread Controlling which code windows open when opening VBA editor in Programming

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...

16 replies | 3402 view(s)

09-22-2025, 08:13 PM

lawdy started a thread

Need help restructuring table and building a form in Forms

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...

15 replies | 3424 view(s)

09-16-2025, 09:17 AM

TOPSie started a thread The old date problem. in Access

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...

6 replies | 4057 view(s)

09-22-2025, 10:26 AM

yrstruly started a thread This Record Set Is Not Updateable in Queries

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

15 replies | 3321 view(s)

10-04-2025, 02:49 PM

GraeagleBill started a thread

Problems attempting to add new record to table in Programming

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...

34 replies | 569 view(s)

09-24-2025, 09:25 AM

matey56 started a thread New records not showing in form in Forms

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...

10 replies | 3038 view(s)

09-12-2025, 08:20 AM

TeO74 started a thread Access 365 with Windows Common Controls in Access

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

8 replies | 3090 view(s)

09-18-2025, 03:21 PM

Carmine started a thread escaping the apostrophe in Access

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

4 replies | 3037 view(s)

09-20-2025, 05:51 PM

lawdy started a thread

Trying to use an update query in Queries

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...

8 replies | 2098 view(s)

09-29-2025, 12:40 AM

TSD started a thread

How create a printable form or report that will print a membership id card in Access

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...

11 replies | 1856 view(s)

09-25-2025, 06:27 AM

ThomasCurcio started a thread Records Listed Out of Order in Form in Forms

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...

5 replies | 2252 view(s)

10-01-2025, 08:08 PM

lawdy started a thread

Don't know how to make an update query in Queries

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

20 replies | 639 view(s)

09-11-2025, 04:32 AM

dizy8 started a thread Value in Textbox 2 depends on Value on Textbox1 in Forms

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...

4 replies | 2463 view(s)

09-29-2025, 11:32 AM

lawdy started a thread

What to do with a no current record query in Queries

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...

5 replies | 2045 view(s)

09-27-2025, 03:26 PM

GraeagleBill started a thread

control OnClick event to make record the current record in Programming

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...

4 replies | 2026 view(s)

10-01-2025, 05:12 PM

Noek started a thread Adding text field to form issue, control source not listed in property sheet in Access

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...

6 replies | 759 view(s)

Yesterday, 11:11 AM

Carmine started a thread Open form with text box blank in Access

THE SITUATION: I have a form that contains a combo box and a text box. The purpose of the form is to correct data misspellings or inaccuracies in a...

7 replies | 114 view(s)

09-26-2025, 02:45 AM

maax555 started a thread

Using a filtered combobox in a form to recall a record in Forms

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....

4 replies | 970 view(s)

Today, 04:43 AM

vinaynaran started a thread Do not display column when total is zeo in Access

Hi all, Part Branch1 Branch2 Branch3 Branch4 Branch5

7 replies | 80 view(s)

10-03-2025, 06:41 AM

maax555 started a thread Forms that add records to a table but also pull records from a different table? in Forms

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...

7 replies | 277 view(s)