Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.35 seconds.
Search: Posts Made By: Beetle
Forum: Tables 06-22-2018, 12:16 PM
Replies: 5
Views: 213
Posted By Beetle
Re: Relationship not working

When working with a main form/sub form scenario, the foreign key value is inserted into the child table via the Master/Child link property of the Subform Control (this is the "window" that holds the...
Forum: Forms 06-21-2018, 07:45 PM
Replies: 8
Views: 225
Posted By Beetle
Re: After_update problem

So now the code will fire every time a user tabs through that control, whether they updated the record or not. Are you sure that's what you want?
Forum: The Watercooler 06-21-2018, 04:52 PM
Replies: 133
Views: 4,346
Posted By Beetle
Re: Trump on Pregnancy

Couldn't agree more Doc. The two major parties in the USA have become two sides of the same coin. You'll get a different image depending on which side of the coin you are looking at, but the basic...
Forum: Modules & VBA 06-21-2018, 07:51 AM
Replies: 10
Views: 251
Posted By Beetle
Re: strsql

Corrected for VBA;

strSQL = "SELECT tblbookings.EventID, tblParticipants.PEmail, tblBookings.AmountPaid, tblEvents.EventName, tblEvents.EventDate, tblParticipants.PName, tblBookings.PLReceived,...
Forum: Modules & VBA 06-21-2018, 05:50 AM
Replies: 10
Views: 251
Posted By Beetle
Re: strsql

This might work;

strSQL = "SELECT tblbookings.EventID, tblParticipants.PEmail, tblBookings.AmountPaid, tblEvents.EventName, tblEvents.EventDate, tblParticipants.PName, tblBookings.PLReceived,...
Forum: Debates 06-18-2018, 01:29 PM
Replies: 25
Views: 2,744
Posted By Beetle
Re: Flat Earth and Hollow Earth Theories

Warms my heart to see a true believer. :)
Forum: Forms 06-18-2018, 11:43 AM
Replies: 4
Views: 166
Posted By Beetle
Re: control if data is saved to a table via form

That's the nature of bound forms. You could use the Before Update event of the form, prompt the user to answer Yes/No to save updates. If they answer No Cancel the update.
Forum: Debates 06-18-2018, 11:19 AM
Replies: 25
Views: 2,744
Posted By Beetle
Re: Flat Earth and Hollow Earth Theories

Speak for your self blasphemer. I had a meeting with the Almighty just last night. Notice how the fork appears to be hovering? That's because it is. I submit this as definitive proof of the FSM.;)
...
Forum: General 06-15-2018, 01:23 PM
Replies: 13
Views: 1,499
Posted By Beetle
Re: I don't want the message of "Enable contents"

You could send the user a accde copy (or mde if it's an older version of Access). As long as you have the navigation pane hidden and all the other properties set in the master copy before you create...
Forum: Debates 06-08-2018, 12:32 PM
Replies: 25
Views: 2,744
Posted By Beetle
Re: Flat Earth and Hollow Earth Theories

After at least 15, maybe 16, minutes of exhaustive research, I have determined that the chem-trails are actually a product of the Agartheans of Hollow Earth (who have secretly taken over most of the...
Forum: Forms 06-08-2018, 07:41 AM
Replies: 1
Views: 124
Posted By Beetle
Re: Subreport Conflict

Cross posted at http://www.accessforums.net/showthread.php?t=72418
Forum: Modules & VBA 05-24-2018, 07:07 AM
Replies: 7
Views: 294
Posted By Beetle
Re: Delete sheet Misery

In addition to the other suggestions, you may need to temporarily turn off alerts in the workbook. Example;


Dim XL As Object

Set XL = CreateObject("Excel.Application")

...
Forum: Forms 05-24-2018, 07:02 AM
Replies: 10
Views: 321
Posted By Beetle
Re: Conditional Formatting Colour

It may have been just me, not the web site. Occasionally, when I try to make contact with my brain, I find it has the invisibility property set to True. :D
Forum: Forms 05-24-2018, 06:06 AM
Replies: 10
Views: 321
Posted By Beetle
Re: Conditional Formatting Colour

Looks like the image in my response #2 didn't post, there seemed to be problems with the site last night, but it was essentially the same thing that June7 and Colin have suggested. No reason that it...
Forum: Forms 05-23-2018, 06:36 PM
Replies: 10
Views: 321
Posted By Beetle
Re: Conditional Formatting Colour

In form design view, select your text box control, go to Conditional Formatting, then enter two conditions using the Expression Is argument and the In operator. It should look like;
...
Forum: Forms 05-22-2018, 12:55 PM
Replies: 7
Views: 236
Posted By Beetle
Re: Closing a form from a current event

I'm not sure I follow the logic here. You have a form that is apparently used for managing client contacts, and as the user moves through the records on that form, if they encounter one where the...
Forum: Forms 05-14-2018, 02:10 PM
Replies: 9
Views: 246
Posted By Beetle
Re: Gray out combo box base on value list

Is this a continuous (aka multiple items) form? if so this is not going to behave like you're expecting. A continuous form is really just one set of Controls that is repeated for each row of data in...
Forum: Access Web 05-11-2018, 06:09 PM
Replies: 5
Views: 1,999
Posted By Beetle
Re: Remote Access to Database

If you're talking about a situation where each remote user actually has a workstation at the home base on the LAN, and they are using VPN to connect to their local machine and run the application...
Forum: Modules & VBA 05-11-2018, 02:20 PM
Replies: 13
Views: 566
Posted By Beetle
Re: Passing child_ID to new post in parent form

Just FYI, you actually can have a continuous main form with a continuous sub form, you just need to place them both on another blank form and use a hidden text box to link them. Not saying you...
Forum: Reports 05-11-2018, 07:53 AM
Replies: 3
Views: 431
Posted By Beetle
Re: Display Field in report if Check Box is true.

Before you begin to get involved in form/report design, I would suggest you rethink this table design. This is going to continually cause problems when you try to design/implement other aspects of...
Forum: Modules & VBA 05-10-2018, 02:15 PM
Replies: 59
Views: 2,507
Posted By Beetle
Re: Help to generate QR Code

The code to create multiple QR codes is already there. Look at the most recent file that June replaced in post #30. There is a button named Mutiple QRCode that will loop through Table1 and create a...
Forum: Modules & VBA 05-08-2018, 11:46 AM
Replies: 28
Views: 1,961
Posted By Beetle
Re: Obtain current geolocation data using VBA

@Colin

I tested using Windows 7 and A2010. It works and accurately gets my current location (in Denver, CO, USA). I also tested moving the accdb and the html file to a different folder from where...
Forum: Queries 05-08-2018, 06:21 AM
Replies: 10
Views: 320
Posted By Beetle
Re: IIf expression

What worked? There were two different solutions offered. It may be helpful to future readers of this thread to know which one worked.
Forum: Queries 05-08-2018, 06:18 AM
Replies: 10
Views: 320
Posted By Beetle
Re: IIf expression

When you say "It returned...", what do you mean by It? What did you try?
Forum: Queries 05-08-2018, 06:11 AM
Replies: 10
Views: 320
Posted By Beetle
Re: IIf expression

It could be that [Value 2] is not actually Null, but rather an empty (zero length) string. Try;

IIf(Nz([Value 2], "")="","",[,sw_] & [Label 2] & [=1] & [Value 2])

On a side note, you should...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:18 AM.


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

Sponsored Links

How to advertise

Media Kit


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