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 | 9149 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 | 5832 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 | 3990 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 | 5028 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 | 4139 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 | 3431 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 | 3437 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 | 4076 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 | 3333 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 | 639 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 | 3054 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 | 3055 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 | 2112 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 | 1888 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 | 2292 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 | 655 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 | 2056 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 | 2044 view(s)

10-09-2025, 08:42 AM

jlindquist23 started a thread Text field missing carriage returns in Access

I'm pulling data from an ODBC table in Sage 100. When the data is viewed in a report in Access, all the carriage returns are ignored and all the...

12 replies | 214 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 | 780 view(s)

10-09-2025, 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

9 replies | 193 view(s)

10-08-2025, 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 | 171 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 | 981 view(s)

Yesterday, 11:17 AM

skunkworks started a thread query not showing in form design selection with command button in Forms

When creating a command button in form design, a delete query does not show. The other query is visible.

11 replies | 62 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 | 344 view(s)

10-01-2025, 06:01 AM

Rainbows5. started a thread Part must have works order issued box ticked before part allows the shipped ticked box being ticke in Programming

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

5 replies | 408 view(s)

10-10-2025, 11:45 AM

FredoC started a thread Variable number of entries in a field in Access

Hello, I am trying to make a nice database for my board game collection, with the name, publisher, year published, # of players etc... One of the...

5 replies | 149 view(s)

10-05-2025, 05:12 PM

kgash started a thread Access locks up after error message in Queries

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

4 replies | 173 view(s)

10-08-2025, 02:24 AM

Matrix started a thread Opted Out of Cloudflare in Forum Suggestions

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

6 replies | 131 view(s)

10-07-2025, 07:41 AM

Gary Frechette started a thread Searching for reference OFFOWC.DLL in Access

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

5 replies | 129 view(s)