Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.23 seconds.
Search: Posts Made By: vbaInet
Forum: Forms 07-22-2015, 08:38 AM
Replies: 10
Views: 3,453
Posted By vbaInet
Re: Setting the default value to the last used value

Did you select Event Procedure and paste it in the code window? And ensure that control name is correct. I would use the After Update event of each control.
Forum: Modules & VBA 07-22-2015, 08:14 AM
Replies: 9
Views: 1,853
Posted By vbaInet
Re: How to send different attachments to different recipients

Concatenate the file name with the field value from the recordset in the Attchments line.
Forum: Modules & VBA 07-22-2015, 08:09 AM
Replies: 6
Views: 607
Posted By vbaInet
Re: VBA Code for IIf statement

I explained how you do it using an Update Query.
Forum: Forms 07-22-2015, 08:03 AM
Replies: 27
Views: 1,670
Posted By vbaInet
Re: Calculated textbox to table

My post came a bit late because I'm logged in from my phone.
Forum: Forms 07-22-2015, 08:01 AM
Replies: 27
Views: 1,670
Posted By vbaInet
Re: Calculated textbox to table

If it's another table that you want to update, create an Update Query that references the calculated value and use RunSql or Currentdb.Execute to fire the query.

Everyone else makes a good point...
Forum: Queries 07-22-2015, 07:48 AM
Replies: 25
Views: 933
Posted By vbaInet
Re: Query "And" on same field

Ah alright, I understood it differently.

I'll take a back seat now that you're back online.
Forum: Queries 07-22-2015, 07:33 AM
Replies: 26
Views: 1,604
Posted By vbaInet
Re: DateDiff Function

She's always looking for new functionality ;)
You can look into the RGB() function.
Forum: Forms 07-22-2015, 07:16 AM
Replies: 24
Views: 7,474
Posted By vbaInet
Re: Create hyperlink to open Access form

I'm not on a pc at the moment but check the DesktopPath variable to ensure that it's returning a value, then step through each line as it runs.
Forum: Modules & VBA 07-22-2015, 07:05 AM
Replies: 6
Views: 780
Posted By vbaInet
Re: Looping through Files - Access holding on to first file name

Very good! :)

Welcome to AWF by the way.
Forum: Modules & VBA 07-22-2015, 07:03 AM
Replies: 6
Views: 719
Posted By vbaInet
Re: Improve Efficiency

Select Count(id) in the recordset sql and return that field value. That's lightening fast. Include a forward only option too.
Forum: Modules & VBA 07-22-2015, 06:55 AM
Replies: 6
Views: 5,108
Posted By vbaInet
Re: Remove "potential security concern"

There's only the registry option.
Forum: Modules & VBA 07-22-2015, 06:52 AM
Replies: 6
Views: 780
Posted By vbaInet
Re: Looping through Files - Access holding on to first file name

Remember I mentioned "Subsequent calls". You've already called it once before the loop so where do you think the next call to Dir() should go? Have a think.
Forum: Modules & VBA 07-22-2015, 06:42 AM
Replies: 4
Views: 547
Posted By vbaInet
Re: Position cursor to left bottom of control

I'm not a laptop at the moment but if I remember correctly certain controls have a Context menu property where you specify the name of a context/pop up menu to allocate to the control. Access handles...
Forum: Modules & VBA 07-22-2015, 06:00 AM
Replies: 14
Views: 1,038
Posted By vbaInet
Re: Report loop -slight issue with ' or ""

I said that in jest :)

But seeing the code you most likely need an Else or Else If statement instead of two If blocks.
Forum: Modules & VBA 07-22-2015, 05:51 AM
Replies: 14
Views: 1,038
Posted By vbaInet
Re: Report loop -slight issue with ' or ""

For your eyes only then ;)
Forum: Modules & VBA 07-22-2015, 05:39 AM
Replies: 14
Views: 1,038
Posted By vbaInet
Re: Report loop -slight issue with ' or ""

Best way to learn and remember ;) What code did you use and what was the result?

It's all related so the same thread is fine.
Forum: Modules & VBA 07-22-2015, 05:30 AM
Replies: 14
Views: 1,038
Posted By vbaInet
Re: Report loop -slight issue with ' or ""

Do stuff and see the result ;)

And I can see that you've chosen to still open the report beforehand.
Forum: Modules & VBA 07-22-2015, 05:24 AM
Replies: 7
Views: 3,385
Posted By vbaInet
Re: External Name not defined

If you Google "how to set a breakpoint in VBA" you should find lots of useful information. Might be best looking for videos on it.
Forum: Modules & VBA 07-22-2015, 05:21 AM
Replies: 6
Views: 780
Posted By vbaInet
Re: Looping through Files - Access holding on to first file name

Following Gasman's advice, subsequent calls to the Dir() function gets the next matching file path.

By the way instead of copying the file across and deleting it, you could move the file... same...
Forum: Modules & VBA 07-22-2015, 03:33 AM
Replies: 7
Views: 3,385
Posted By vbaInet
Re: External Name not defined

Oh I see. You can't run that sub in the immediate window. Only public functions or subs in a Standard Module (not a Form Module) can be run from the immediate window. You can however put a break...
Forum: Modules & VBA 07-22-2015, 03:05 AM
Replies: 7
Views: 3,385
Posted By vbaInet
Re: External Name not defined

Can you indicate which line causes the error.
Forum: Modules & VBA 07-22-2015, 02:54 AM
Replies: 10
Views: 888
Posted By vbaInet
Re: Sequence Numbers

What's the question?
Forum: Reports 07-22-2015, 02:49 AM
Replies: 2
Views: 462
Posted By vbaInet
Forum: Modules & VBA 07-22-2015, 02:42 AM
Replies: 15
Views: 990
Posted By vbaInet
Re: UNC Links

There are comments inline. Copy the relevant parts from there and add it to yours. Then ask specific questions.
Forum: General 07-22-2015, 02:36 AM
Replies: 7
Views: 945
Posted By vbaInet
Re: Attachment Datatype and viewing images in reports

Is it only the spreadsheet that will be included in the report? Tell your boss that it's just not feasible. A spreadsheet spans much wider than an Access report. The spreadsheet can and should be...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World