Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 257
Search took 0.05 seconds.
Search: Posts Made By: Insane_ai
Forum: Introduce Yourself 09-13-2019, 10:50 AM
Replies: 8
Views: 153
Posted By Insane_ai
Forum: General 09-05-2019, 06:35 AM
Replies: 32
Views: 512
Posted By Insane_ai
Re: Run Access VBA code from .bat file

Taking from GasMan's example, Here is what the code should look like when you run it from a single database.



Sub TestSubInAnotherDB()
Dim appAccess As Access.Application
Dim strFileName As...
Forum: General 09-05-2019, 03:16 AM
Replies: 32
Views: 512
Posted By Insane_ai
Re: Run Access VBA code from .bat file

Please post the code you used so we can help you better.
Forum: General 09-04-2019, 08:45 AM
Replies: 32
Views: 512
Posted By Insane_ai
Re: Run Access VBA code from .bat file

This may be of assistance:

Windows batch script - How to filter files with defined extension...
Forum: General 09-04-2019, 08:41 AM
Replies: 32
Views: 512
Posted By Insane_ai
Re: Run Access VBA code from .bat file

your batch file would look something like this:

"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /x MacroName

"C:\Program Files (x86)\Microsoft Office\root\Office16\msaccess.exe"...
Forum: Access World News 09-04-2019, 08:36 AM
Replies: 16
Views: 4,828
Posted By Insane_ai
Re: Site down - out of memory

Any word on the HTTP 500 errors lately?
Forum: Introduce Yourself 09-04-2019, 03:12 AM
Replies: 3
Views: 78
Posted By Insane_ai
Re: Hello from Zimbabwe!

Welcome to AWF!
Forum: Forms 09-04-2019, 03:12 AM
Replies: 5
Views: 119
Posted By Insane_ai
Re: Cascading combo-boxes in table form

Can you post the code used to update the combo boxes please? It would help us find the error. Also, please verify the names of the combo boxes; it looks like you may have copied and pasted them so...
Forum: Modules & VBA 08-30-2019, 06:30 AM
Replies: 5
Views: 103
Posted By Insane_ai
Re: Start macro, or return to form after answering yes or no

try something like this:


Dim varResponse As Variant
varResponse = MsgBox("Have you updated the link yet?", vbYesNo, "My Title here")
If varResponse = vbYes Then
'run macros
...
Forum: Introduce Yourself 08-30-2019, 06:16 AM
Replies: 4
Views: 90
Posted By Insane_ai
Re: New to forumm

Welcome to AWF and Happy coding!
Forum: Introduce Yourself 08-27-2019, 03:15 AM
Replies: 3
Views: 97
Posted By Insane_ai
Re: New member here

Welcome to AWF!
Forum: General 08-23-2019, 09:51 AM
Replies: 20
Views: 223
Posted By Insane_ai
Re: Event procedure not working on opening until VBA code is opened and closed

Sometimes a decompile / recompile is needed to work these bugs out. Here's an example for you:

"C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE"...
Forum: Introduce Yourself 08-23-2019, 09:42 AM
Replies: 3
Views: 72
Posted By Insane_ai
Re: Intro

Welcome to the forums!
Forum: General 08-23-2019, 09:38 AM
Replies: 8
Views: 169
Posted By Insane_ai
Re: Milage recording

The point is to create a paper definition so your report prints on the stock as needed. you can choose any printer other than win2pdf to get to the print server specifications. Another way is to...
Forum: General 08-22-2019, 03:25 AM
Replies: 8
Views: 169
Posted By Insane_ai
Re: Milage recording

You may need to create the custom paper definition. Here's a quick tutorial.

https://www.win2pdf.com/doc/pdf-custom-paper-windows-10.html...
Forum: Modules & VBA 08-13-2019, 06:29 AM
Replies: 13
Views: 238
Posted By Insane_ai
Re: Open specific folder to link image

Give this a read, it covers the file dialogue pretty well.

https://analystcave.com/vba-application-filedialog-select-file/ (https://analystcave.com/vba-application-filedialog-select-file/)
Forum: Politics & Current Events 08-09-2019, 05:59 AM
Replies: 433
Views: 25,130
Posted By Insane_ai
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

The problem isn't how crazy she is, it's how many people support her brand of crazy.
Forum: The Watercooler 08-08-2019, 11:25 AM
Replies: 8
Views: 195
Posted By Insane_ai
Re: Euromillions lottery and luck

The lottery is an entertainment expense, not an investment strategy. - my .02
Forum: The Watercooler 08-06-2019, 09:48 AM
Replies: 6
[SOLVED] Gender Neutral?
Views: 148
Posted By Insane_ai
Re: Gender Neutral?

What about those who claim no gender?
Forum: Modules & VBA 07-31-2019, 03:58 AM
Replies: 13
Views: 276
Posted By Insane_ai
Re: Field 'F1' doesn't exist in destination table

Thanks to everyone who contributed and I apologize for not responding faster. I kept getting HTTP 500 errors yesterday when I tried to log in to the site.

The solution was a one liner to invoke...
Forum: Modules & VBA 07-29-2019, 04:43 AM
Replies: 13
Views: 276
Posted By Insane_ai
Re: Field 'F1' doesn't exist in destination table

Yes, even going through the advanced feature to choose the import spec. during the manual import. On a side note, it doesn't seem to matter whether I choose the spec or not during a manual import. ...
Forum: Modules & VBA 07-26-2019, 09:01 AM
Replies: 13
Views: 276
Posted By Insane_ai
Re: Field 'F1' doesn't exist in destination table

That was one of the first things I tried. I don't understand why this works manually but runs into problems when automating it.
Forum: Modules & VBA 07-26-2019, 07:07 AM
Replies: 13
Views: 276
Posted By Insane_ai
Re: Field 'F1' doesn't exist in destination table

No, the file I'm working with does not have field names. It's a raw CSV dump that I have to manipulate.
Forum: Modules & VBA 07-26-2019, 06:21 AM
Replies: 13
Views: 276
Posted By Insane_ai
Re: Field 'F1' doesn't exist in destination table

Adding quotes around the specification causes Run-time error '3001' Invalid argument.
Forum: Modules & VBA 07-26-2019, 05:44 AM
Replies: 13
Views: 276
Posted By Insane_ai
Field 'F1' doesn't exist in destination table

I am working to automate an import. I have defined the import specification and it works if I run it manually but it fails when called by VBA.


Public Function SelectFile(Optional ByVal sFilter...
Showing results 1 to 25 of 257

 
Forum Jump



All times are GMT -8. The time now is 07:09 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