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

Today, 09:49 AM

Minty replied to a thread Coding help!!!! in Access

You could do a totals query restricted to the last seven days and simply display that in a small read only subform or even better a list box, rather...

4 replies | 43 view(s)

Today, 09:42 AM

Welshgasman replied to a thread Coding help!!!! in Access

I do not see any attachment as you are on my IL :) Just Google both those functions and get to understand them. They work very Veryan similar,...

4 replies | 43 view(s)

Today, 09:36 AM

mike60smart replied to a thread Making a query updatable in Queries

The attached is a simple Main Form Subform to cover your Patient Visits process.

17 replies | 1319 view(s)

Today, 09:07 AM

mike60smart replied to a thread Filling multiple fields based on value in Access

Can you upload what you currently have?

3 replies | 36 view(s)

Today, 09:01 AM

xps35 replied to a thread Filling multiple fields based on value in Access

I guess that the fields are unbound and not stored because they are stored in the "other table". So it looks ok.

3 replies | 36 view(s)

Today, 08:23 AM

deepaksharma replied to a thread Coding help!!!! in Access

Thanks for reply Can you tell me proper coding according to attachment

4 replies | 43 view(s)

Today, 08:18 AM

Welshgasman replied to a thread Coding help!!!! in Access

Look at DSum() and DCount() Use required criteria as needed.

4 replies | 43 view(s)

Today, 08:09 AM

deepaksharma started a thread Coding help!!!! in Access

My greetings to all of you. I need help from all of you with coding. I have created a program which is made up of main form (offerentry) and sub...

4 replies | 43 view(s)

Today, 07:46 AM

mike60smart replied to a thread Filling multiple fields based on value in Access

If The fields are not bound then you will need VBA

3 replies | 36 view(s)

Today, 07:09 AM

AhmedHashish started a thread Filling multiple fields based on value in Access

Hello, I have created 1 combobox(list) and 3 text boxes that have dlookup function, so when I choose a value from a combox it populates text from...

3 replies | 36 view(s)

Today, 06:41 AM

Minty replied to a thread Open report in Access

The simple explanation is that until Access opens the report to create the PDF, there is nothing to attach.

1 replies | 35 view(s)

Today, 05:04 AM

CJ_London replied to a thread Stop textbox scrolling to top when clicked out in Forms

Investigate selstart property something like txtctl.selstart=len(txtctl) in the got focus event edit: wrong answer but left in case of...

2 replies | 79 view(s)

Today, 04:54 AM

Bunic000 started a thread Open report in Access

Good morning everyone, I use this VBA below to email documents to the customers. Almost everything works as I would like, but I still have a...

1 replies | 35 view(s)

Today, 03:44 AM

Minty replied to a thread Stop textbox scrolling to top when clicked out in Forms

Short answer - Not that I am aware of. Access doesn't have a bottom alignment option for text boxes.

2 replies | 79 view(s)

Today, 03:40 AM

stu_C started a thread Stop textbox scrolling to top when clicked out in Forms

Hi all when I have a lot of text in a text box and then click out of it it seems to automatically scroll to the top of the textbox, is there a way...

2 replies | 79 view(s)

Today, 01:59 AM

Welshgasman replied to a thread Making a query updatable in Queries

Are you replying to the correct thread?

17 replies | 1319 view(s)

Yesterday, 08:45 PM

June7 replied to a thread Choose Function Limitations in Access

That looks like a non-normalized data structure. See nothing wrong with expression. Now I would have to examine data. If you want to provide db...

3 replies | 94 view(s)

Yesterday, 07:58 PM

Josh330 replied to a thread Choose Function Limitations in Access

Hi June. The below formula works in the Query. The output is a date field. Please excuse the unsophisticated field names. Task 010 Start:...

3 replies | 94 view(s)

Yesterday, 07:32 PM

June7 replied to a thread Choose Function Limitations in Access

I just tested Choose with 26 elements in VBA and it works. There is a limit of 1024 characters in cell of query design grid. Post your code.

3 replies | 94 view(s)

Yesterday, 06:32 PM

Josh330 started a thread Choose Function Limitations in Access

Hi there. Are there limitations to the Choose function? Such as maximum number of values? For the values, I am using fields. I am asking because I am...

3 replies | 94 view(s)

Yesterday, 05:30 PM

DPR01 replied to a thread Making a query updatable in Queries

Thank you for your response. I will checkout the links and see if I can find the normalizing opportunities in my database. Have a Blessed Evening.

17 replies | 1319 view(s)

Yesterday, 03:17 PM

isladogs replied to a thread Photo Attachment in Forms

On the same point as the last post, see my example app: Folder Image Viewer (isladogs.co.uk)

4 replies | 227 view(s)

Yesterday, 02:57 PM

willkr replied to a thread

Query from two tables in Access

OK, I figured out how to link the new table and now the start-up error messages have gone away. Now I have to go through and test all the routines...

13 replies | 168 view(s)

Yesterday, 02:54 PM

willkr replied to a thread

Query from two tables in Access

I have other savings tables that track things like credits and debits entered as part of the reconciliation process. I also have a table with savings...

13 replies | 168 view(s)

Yesterday, 02:53 PM

Welshgasman replied to a thread

Query from two tables in Access

Have you linked the new table?

13 replies | 168 view(s)

Yesterday, 02:50 PM

willkr replied to a thread

Query from two tables in Access

Another thing I noticed: When I start the app now I get the following message: The Microsoft Access database engine cannot find the input table or...

13 replies | 168 view(s)

Yesterday, 02:48 PM

ArviLaanemets replied to a thread

Query from two tables in Access

Do you really have all those spaces in your field names? It will be a pain you know where to enter all those brackets when writing scripts or queries!

13 replies | 168 view(s)

Yesterday, 02:40 PM

Welshgasman replied to a thread

Query from two tables in Access

I would just call it tblSavings. It is a given it is for deposits and withdrawals. You need to link the new table from the FE.

13 replies | 168 view(s)

Yesterday, 02:37 PM

willkr replied to a thread

Query from two tables in Access

The tables have slightly different forms. There is no real data in them currently, so I don't need to save any of the data. I created a new table...