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, 02:49 AM

DMT Dave replied to a thread Email Loop in Access

Hi Vlad, thank you, will certainly..... Kindest

3 replies | 83 view(s)

Yesterday, 04:48 PM

Gicu replied to a thread

Need to INSERT default value into multiple tables in Programming

You're very welcome Tom! Cheers,

18 replies | 164 view(s)

Yesterday, 04:09 PM

Micron replied to a thread Paste append in Access

Same code. Just change the number.

6 replies | 95 view(s)

Yesterday, 03:35 PM

skydivetom replied to a thread

Need to INSERT default value into multiple tables in Programming

Yet another **PERFECT** solution. Thousand thanks, Vlad. I love your simplistic way of solving these type of questions.

18 replies | 164 view(s)

Yesterday, 03:15 PM

June7 replied to a thread New Database Design Concept & Forms Question in Access

Would not have two subforms. Have main form bound to Products with subform bound to Recipes and a combobox to select ingredients. Use combobox...

1 replies | 55 view(s)

Yesterday, 03:02 PM

Gicu replied to a thread

Need to INSERT default value into multiple tables in Programming

Hi Tom, The error (Invalid Operation) was my fault, wrote the code in Notepad so it was missing the ".Type" (like in Select Case T.Fields(0).Type...

18 replies | 164 view(s)

Yesterday, 03:01 PM

Pawtang started a thread New Database Design Concept & Forms Question in Access

I am starting a new project here and want to make sure I am on the right track with how I'm laying this out... The idea is to be able to track the...

1 replies | 55 view(s)

Yesterday, 02:58 PM

Gicu replied to a thread

Need to INSERT default value into multiple tables in Programming

Hi Tom, Here you are, ended up checking the data type as the date fields would accept a number and vice versa. Cheers, Vlad

18 replies | 164 view(s)

Yesterday, 02:52 PM

cbuechner replied to a thread Paste append in Access

run time error 2237

6 replies | 95 view(s)

Yesterday, 02:47 PM

GraeagleBill replied to a thread Functions - Scope of visibility within Access in Programming

Yes, the "=DelRes(0)" function you see specified in the 1st of the two OP images is coded in the form's module and executes normally when the "Delete...

2 replies | 54 view(s)

Yesterday, 02:44 PM

moke123 replied to a thread

form recordset mess up the form in Access

The first picture in Post#9 you set db = currentdb but there is no indication you dimmed it. Do you have option explicit declared in every module?

13 replies | 211 view(s)

Yesterday, 02:41 PM

Micron replied to a thread Creating an invoice from a form in Forms

"How to Attach Files" is in the top menu, if that helps.

4 replies | 118 view(s)

Yesterday, 02:35 PM

Micron replied to a thread Paste append in Access

Probably 4605 but would sure be nice if everybody divulged these numbers. One way to trap Private Sub Command14_Click() On Error GoTo errHandler...

6 replies | 95 view(s)

Yesterday, 02:24 PM

isladogs replied to a thread Paste append in Access

Please test what error number/description occurs so we can tell you how to do a work-round

6 replies | 95 view(s)

Yesterday, 02:21 PM

cbuechner replied to a thread Paste append in Access

Can it be ignore it if its a VBA generated error for just this error?

6 replies | 95 view(s)

Yesterday, 02:13 PM

Micron replied to a thread Paste append in Access

Always better to prevent errors where possible but I don't know how to test for an empty clipboard. I suspect you could trap the error easily enough...

6 replies | 95 view(s)

Yesterday, 02:09 PM

Micron replied to a thread Functions - Scope of visibility within Access in Programming

IIRC, only public functions in standard module could be called by custom menus. You're saying that is not the case? Does this help?...

2 replies | 54 view(s)

Yesterday, 02:08 PM

skydivetom replied to a thread

Need to INSERT default value into multiple tables in Programming

Vlad - I went back to used the function provided in post #12. This was seems to be using the CASE statement to ensure only a single record is...

18 replies | 164 view(s)

Yesterday, 01:28 PM

Bob Fitz replied to a thread Creating an invoice from a form in Forms

Compact and repair the db, then zip it before posting it.

4 replies | 118 view(s)

Yesterday, 01:26 PM

cbuechner started a thread Paste append in Access

I am adding a paste append in the form, and it works. But I need to add a part that if there is nothing to append, it doesn't create a run time...

6 replies | 95 view(s)

Yesterday, 01:15 PM

Wingnut74 replied to a thread Creating an invoice from a form in Forms

Hi Bob, Thanks for the prompt reply. I have stripped out the DB I've been working on due to the sensitive data but I am now having trouble...

4 replies | 118 view(s)

Yesterday, 01:10 PM

Micron replied to a thread

Need to INSERT default value into multiple tables in Programming

I gather then that you are not using an autonumber as a PK and you must be using meaningful data instead. That's another reason to stick with AN if...

18 replies | 164 view(s)

Yesterday, 01:07 PM

Welshgasman replied to a thread Project wise weekly timesheets in Database Design

And the templates?

5 replies | 103 view(s)

Yesterday, 01:00 PM

skydivetom replied to a thread

Need to INSERT default value into multiple tables in Programming

Vlad: Apparently, it still doesn't work as anticipated. Allow me to attach the sample database. Process - DB opens with form "F01_MainMenu"...

18 replies | 164 view(s)

Yesterday, 12:00 PM

GraeagleBill started a thread Functions - Scope of visibility within Access in Programming

I have several "old apps" that when developed used "Right-click" functions extensively. In most cases, the right-click function involved launching a...

2 replies | 54 view(s)

Yesterday, 11:48 AM

Gicu replied to a thread

form recordset mess up the form in Access

It probably will be a bit faster but the constant emptying and populating of the local table will bloat the front-end so it will need to be compacted...

13 replies | 211 view(s)

Yesterday, 11:40 AM

Gicu replied to a thread

Need to INSERT default value into multiple tables in Programming

With dbDate ublic Sub DeleteRecordsFreeForm() Dim T As TableDef Dim n As Integer DoCmd.SetWarnings False

18 replies | 164 view(s)

Yesterday, 11:37 AM

Gicu replied to a thread

Need to INSERT default value into multiple tables in Programming

Hi Tom, Here are two versions: Public Sub DeleteRecordsFreeForm() Dim T As TableDef Dim n As Integer DoCmd.SetWarnings...