Go Back   Access World Forums > Search Forums

Showing results 1 to 24 of 24
Search took 1.27 seconds.
Search: Posts Made By: Insane_ai
Forum: Introduce Yourself 10-10-2019, 09:38 AM
Replies: 4
Views: 64
Posted By Insane_ai
Re: Noobie on the scene

Welcome to AWF!
Forum: General 08-23-2019, 09:38 AM
Replies: 8
Views: 170
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: 170
Posted By Insane_ai
Re: Milage recording

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

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: Queries 11-02-2018, 06:57 AM
Replies: 4
Views: 168
Posted By Insane_ai
Re: UK dates in SQL queries

You may want to review this:
Bad Habits to kick mis handling data range queries:

After digesting this I use only...
Forum: Code Repository 10-04-2018, 12:15 PM
Replies: 9
Views: 2,583
Posted By Insane_ai
Strobe Effect - VBA

I needed this but couldn't find it so I created it. I am open to suggestions to improve the code.

Option Compare Database
Option Explicit
Public Declare Sub Sleep Lib "Kernel32" (ByVal...
Forum: Forms 08-31-2018, 05:16 AM
Replies: 3
Views: 108
Posted By Insane_ai
Re: Changing format in data table below chart object

This format works for me in the debug window

debug.Print Format("4096","# ##0")
4 096

Maybe this article will help a bit more....
Forum: Introduce Yourself 08-31-2018, 05:09 AM
Replies: 7
Views: 266
Posted By Insane_ai
Re: Old Dog Learning New Tricks

Welcome to the forums!

Sometimes it's better to be lucky than good. I wish good luck! (You'll have to handle the being good on your own)
Forum: Modules & VBA 08-29-2018, 05:33 AM
Replies: 6
Views: 573
Posted By Insane_ai
Re: Office 2016 Access VBA sending XML

Microsoft Soap Type Library v3.0

Since these articles seem to be disappearing I'll include the primary content form the page:...
Forum: Queries 08-22-2018, 01:41 PM
Replies: 4
Views: 93
Posted By Insane_ai
Re: Show Source of Data in Query without adding another field?

You would have to add the additional field as you build each of the source queries that are used in the Union or make a calculated field with all of them before the union.

it would look something...
Forum: Queries 08-17-2018, 12:27 PM
Replies: 18
Views: 1,535
Posted By Insane_ai
Re: Update fldSOI to 1 based on calcs - need some help

Please help me understand what you need.
1. Fix the query
2. Schedule it to run daily.

If #2 then
1. Create a Macro that invokes the query, include action to close the database after.
Forum: Sample Databases 08-10-2018, 10:22 AM
Replies: 7
Views: 1,494
Posted By Insane_ai
Re: Security Challenge #2

Thank you Ridders!

These exercises taught me about things I never thought to look for.

I am going to give one spoiler:

Don't over think it; pay attention to what is in front of you.
Forum: General 08-07-2018, 09:57 AM
Replies: 12
Views: 1,217
Posted By Insane_ai
Re: Counting courses and calculating GPA

I've attached a copy of your database example with the queries built to do what you describe (or at least how I interpret your description).

Objective 1: List count of classes for students...
Forum: Modules & VBA 03-14-2014, 10:43 AM
Replies: 3
Views: 828
Posted By Insane_ai
Re: Dos commands in Access vba

Search for FileSystemObject in this forum for help, there are many posts on the subject.

When using FileSystemObject, you are actually using VBA to call VBScript code.

Start with:

Forum: Modules & VBA 03-14-2014, 09:44 AM
Replies: 1
Views: 356
Posted By Insane_ai
Re: Extract variable count of columns


Option Base 1


For I = 0 to (12-actuals)

By default, VBA starts counting at zero.
Forum: Modules & VBA 03-14-2014, 07:56 AM
Replies: 3
Views: 558
Posted By Insane_ai
Re: beginner vba sql query question

The example I provided is from a VBA project / Access 2007. As long as the variable type is declared as a Date, you should be fine. I have found that using a string like 1/1/2001 must be wrapped...
Forum: Modules & VBA 03-14-2014, 06:40 AM
Replies: 3
Views: 558
Posted By Insane_ai
Re: beginner vba sql query question

Have you tried using the query builder? Copy the SQL then adjust the where clause with variables in code.

Here's an example of one of my WHERE clauses built in VBA:

" WHERE...
Forum: Tables 01-31-2013, 10:24 AM
Replies: 15
Views: 1,728
Posted By Insane_ai
Re: Conditional values in the table.

Try this instead:

UPDATE Funds INNER JOIN Classes ON (Funds.Fund_Name = Classes.Fund_Name) AND (Funds.Fund_Name = Classes.Fund_Name) SET Funds.Active = Yes
WHERE (((Funds.Active)=No) AND...
Forum: Tables 01-30-2013, 11:02 AM
Replies: 15
Views: 1,728
Posted By Insane_ai
Re: Conditional values in the table.

If you have a query like this to count the open Items:
Query: closed_count

SELECT Classes.fund_name, Count(Classes.[Open/Closed]) AS [CountOfOpen/Closed]
FROM Classes
Forum: Reports 05-01-2012, 12:20 PM
Replies: 7
Views: 3,531
Posted By Insane_ai
Re: Filter Report by combo box selection

If each author has a unique id associated with them, use that field in your combo box as the Bound Column and reference that ID in your filter. So if the rowsource = Select ID, (LastName & ", " &...
Forum: Modules & VBA 03-26-2012, 12:48 PM
Replies: 3
Views: 915
Posted By Insane_ai
Re: Dlookup issue

strUsername = Nz(Dlookup ("USERNAME","AUTHORISATION","AUTHORISATION.USERNAME= " & Forms!PASSWORDS.[Text43]),"NoAuth")

If strUserName = "NoAuth" then
msgbox "You have no permission for this"...
Forum: General 03-26-2012, 12:29 PM
Replies: 3
Views: 1,632
Posted By Insane_ai
Re: unhide main db window

Method 1:
Try pressing the F11 key once the database is open.

Method 2:

find the database file in using a file explorer (My computer).
single click the file
Press and hold the shift key,...
Forum: General 03-21-2012, 05:40 AM
Replies: 1
Views: 2,162
Posted By Insane_ai
Re: Deploy 2007 as runtime, trusted location

I fought with this for a while and eventually figured out the solution based on the thread referenced above, and "Hey, Scripting Guy" posts. Below is a template script that is working on my network;...
Forum: Sample Databases 03-25-2009, 05:22 AM
Replies: 0
Views: 7,029
Posted By Insane_ai
Automatically populate a field using a field on another form

Here is the sample I created in respons to the above named thread for SikhSioux.
Showing results 1 to 24 of 24

Forum Jump

All times are GMT -8. The time now is 07:35 AM.

Microsoft Access Help
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