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, 08:35 PM

Edgar replied to a thread Calling Module from a form. in Modules

What kind of network are you speaking of? are you planning to move this to a web environment? The suggestion of placing everything in one form...

27 replies | 301 view(s)

Today, 05:24 PM

Perfac replied to a thread Calling Module from a form. in Modules

It seems you understand correct. I will start to aplly that now. Been elsewhere for 7 hours, caught some sleep. From which country are you? ...

27 replies | 301 view(s)

Today, 04:23 PM

cp3 started a thread Linked Database in Access

Hi all, I have a database that's linked (front end and back end) and there is a sub form that's been giving me an interesting error. It only...

0 replies | 29 view(s)

Today, 01:34 PM

Edgar replied to a thread Calling Module from a form. in Modules

If I understood well, in every form, the field and control will be named differently but each form will have them with the same names, if that is so,...

27 replies | 301 view(s)

Today, 11:58 AM

June7 replied to a thread

keep query sql formatting in Access

I use Notepad++ for a quick check of paren pairing and highlight key words.

5 replies | 87 view(s)

Today, 11:14 AM

kd2017 replied to a thread

keep query sql formatting in Access

I agree it's pretty annoynng that access loses your formatting... I also agree that your formatting is quite difficult to read. When I need to...

5 replies | 87 view(s)

Today, 10:33 AM

Welshgasman replied to a thread

keep query sql formatting in Access

Personally I think the the picture is madness. I am all for spacing clearly, but that is awful. :)

5 replies | 87 view(s)

Today, 10:15 AM

diegomarino replied to a thread

keep query sql formatting in Access

thanks, i think this works only for where clause, not for the text formatting of sql. Just tried. however it's good enogh, thanks

5 replies | 87 view(s)

Today, 10:08 AM

June7 replied to a thread

keep query sql formatting in Access

If you save the query from SQL view with structure you prefer and never open in design view, it might retain that structure.

5 replies | 87 view(s)

Today, 09:39 AM

Perfac replied to a thread Calling Module from a form. in Modules

Thank you very much Edgar. I will test and reply to you, it looks good. My protocol is to never name a control the same as a field. If the fieldname...

27 replies | 301 view(s)

Today, 09:35 AM

Welshgasman replied to a thread Calling Module from a form. in Modules

Well spotted. :) I missed that completely. :( Edit: Strangely, the first and last worked fine?

27 replies | 301 view(s)

Today, 09:28 AM

moke123 replied to a thread Calling Module from a form. in Modules

My Bad GasMan. I added the last set of buttons just before I posted and did it by copy and paste. I had Set clsNB4 = New clsFormNavBar...

27 replies | 301 view(s)

Today, 09:25 AM

diegomarino started a thread

keep query sql formatting in Access

Sorry, maybe a silly question but i'd like to keep the sql formatted as i did, like in the pic moreover, i made a query in which the WHERE...

5 replies | 87 view(s)

Today, 09:09 AM

davegri replied to a thread Calling Module from a form. in Modules

Nothing wrong with Class code itself, just an invocation error on the form. The red original was clsNB3. Option Compare DatabaseOption...

27 replies | 301 view(s)

Today, 09:07 AM

Micron replied to a thread How to limit permitted combinations in a junction table in Database Design

I think I get it, but example data for allowed/not allowed would help. You'd handle this at the form level, not the table level, by using cascading...

2 replies | 78 view(s)

Today, 08:42 AM

Edgar replied to a thread Calling Module from a form. in Modules

If you want to make this work from a module: Private Sub btn08TutorialScript_Click() Dim mydoc As String mydoc =...

27 replies | 301 view(s)

Today, 07:37 AM

Bradders92 replied to a thread

Starting from scratch Excel to Access in Access

Thanks all for the advice and to the people who’ve also sent private messages offering to help too. I feel less daunted on doing something with...

10 replies | 224 view(s)

Today, 07:19 AM

Perfac replied to a thread Calling Module from a form. in Modules

Yes. Do you get what I am asking? Any way that will have the required result will do.

27 replies | 301 view(s)

Today, 07:15 AM

CJ_London replied to a thread Calling Module from a form. in Modules

I presume you are referring to this mydoc = "D:\Attachments\InformationPages\f6FieldNames.docx" if so June was suggesting mydoc =...

27 replies | 301 view(s)

Today, 06:49 AM

Welshgasman replied to a thread Calling Module from a form. in Modules

Very nice moke123. I cannot get a messagebox up on classbar 3 though? I can go to the last record and if I press next, nothing. It does work on...

27 replies | 301 view(s)

Today, 06:45 AM

Perfac replied to a thread Calling Module from a form. in Modules

CJ. I assume June is very busy. I am keen to learn what he advised me to do in #10. If you read what I wrote in #9, can you help? I need to be spoon...

27 replies | 301 view(s)

Today, 06:35 AM

moke123 replied to a thread Calling Module from a form. in Modules

As Edgar said, there are many ways to accomplish things in access. I use a navbar class to navigate form recordsets. This includes several...

27 replies | 301 view(s)

Today, 06:06 AM

Perfac replied to a thread Calling Module from a form. in Modules

Sorry. You said that clearly, and I understand now not an hour ago. I will consider it; it sounds good. From starters 7 years ago to the current 10...

27 replies | 301 view(s)

Today, 05:23 AM

CJ_London replied to a thread Calling Module from a form. in Modules

Not sure why you think the subform would not be visible - it has the buttons to execute the code

27 replies | 301 view(s)

Today, 05:10 AM

orange replied to a thread How to limit permitted combinations in a junction table in Database Design

I suggest you tell us about your "business" in simple, plain English terms. Sometimes we get too close to the problem and lose perspective. Also,...

2 replies | 78 view(s)

Today, 04:08 AM

Perfac replied to a thread Calling Module from a form. in Modules

Hi CJ. Thanks, for me learning of your idea. 1. I could have 10 items of VBA code that are on every of the more than 100 forms that are the same....

27 replies | 301 view(s)

Today, 03:50 AM

Perfac replied to a thread Calling Module from a form. in Modules

June7. Let us say all the different forms have a field with same fieldname "FormName" in the record source. The different names of the forms will...

27 replies | 301 view(s)

Today, 03:43 AM

CJ_London replied to a thread Calling Module from a form. in Modules

depending on where these buttons are, one of the things I do is to have a subform to contain the buttons such as you show in post #8. The code...

27 replies | 301 view(s)

Today, 03:26 AM

Remster started a thread How to limit permitted combinations in a junction table in Database Design

I'm suffering from brain failure here. How, at the level of tables and relationships, do I limit the permitted combinations of values in...

2 replies | 78 view(s)

Today, 03:12 AM

June7 replied to a thread Calling Module from a form. in Modules

Sure, can concatenate a field to literal string to build document file path. If field is in form's RecordSource, just reference it.

27 replies | 301 view(s)