Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 443
Search took 0.29 seconds.
Search: Posts Made By: Beetle
Forum: Tables 06-22-2018, 12:16 PM
Replies: 5
Views: 244
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: The Watercooler 06-21-2018, 04:52 PM
Replies: 133
Views: 4,849
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: Forms 05-24-2018, 06:06 AM
Replies: 10
Views: 386
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: 386
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: 277
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: Modules & VBA 05-11-2018, 02:20 PM
Replies: 13
Views: 613
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: Queries 05-08-2018, 06:11 AM
Replies: 10
Views: 366
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...
Forum: Macros 04-24-2018, 10:40 AM
Replies: 14
Views: 645
Posted By Beetle
Re: Table Data Macro Issues

I have reattached your sample db. I modified your data macro and added an Update query (Query1) for tblRoster. If you change the criteria for the update query and run it you'll see that the Notes...
Forum: Forms 04-12-2018, 12:23 PM
Replies: 7
Views: 349
Posted By Beetle
Re: Requery a dropdown field

OK, just call the Project Number After Update event in the Current event of the sub form;

Private Sub Form_Current()
End Sub
Forum: Forms 04-02-2018, 03:06 PM
Replies: 28
Views: 951
Posted By Beetle
Re: Form that updates/adds to part of database

Didn't get a chance to post back a sample file yet but I see that Pat did based on your original table structure. If that example will work for you then I won't post so as not to confuse the issue...
Forum: Forms 03-30-2018, 08:46 AM
Replies: 28
Views: 951
Posted By Beetle
Re: Form that updates/adds to part of database

Your last statement confirms what I have been saying. A Croc can have multiple Encounters and Encounters can have multiple Crocs. Even though the main purpose of the application may be Crocodile...
Forum: Forms 03-29-2018, 12:05 PM
Replies: 28
Views: 951
Posted By Beetle
Re: Form that updates/adds to part of database

So if that happens do you;

A. Need to keep the record with the old information that is now no longer valid and enter a new record with the new information.


B. Overwrite the existing...
Forum: Forms 03-21-2018, 09:37 AM
Replies: 4
[SOLVED] Subdatasheet
Views: 321
Posted By Beetle
Re: Subdatasheet

What did you try? Did you add a text box control to the main form and use it as the Master link source for your second subform?
Forum: Modules & VBA 09-30-2017, 08:06 AM
Replies: 6
Views: 676
Posted By Beetle
Re: Filter Upon Filter in Continuous Form

You could use something like the following (aircode);

Dim strWhere As String

If Nz(Me.Combo1, vbNullString) <> vbNullString Then
strWhere = strWhere & "([Field1]=""" & Me.Combo1 &...
Forum: Queries 02-20-2017, 08:27 PM
Replies: 2
Views: 585
Posted By Beetle
Re: DSum

If the data types of EmployeeID and BenefitsID are numeric, then;

DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=" & [tbpayrolldeduction]![EmployeeID] & " And [BenefitsID] ="...
Forum: Modules & VBA 02-16-2017, 07:03 PM
Replies: 5
Views: 848
Posted By Beetle
Re: Hyperlink removal with VBA?

You might try the following code line, keep in mind that you need to make sure the text box has focus first;

DoCmd.RunCommand acCmdClearHyperlink
Forum: Modules & VBA 02-16-2017, 06:12 PM
Replies: 8
Views: 640
Posted By Beetle
Re: Compile Error

See the example below. The line in red is what you need to add to your code.

Private Sub btnSearchCarlsbad_Click()
Dim strString As String
Dim strText As String
Dim strSearch As String
Forum: General 02-15-2017, 07:27 PM
Replies: 2
Views: 603
Posted By Beetle
Re: Help with select case on combobox

It is generally not a good idea to store data in this manner, however, if you want to do this I don't really see a need for a Select Case here based on your description. You are going to use a combo...
Forum: Forms 02-13-2017, 09:02 PM
Replies: 6
Views: 1,326
Posted By Beetle
Re: Prevent move to next record IF ...

This is not fully tested, but you might give it a try. Replace the text in red with your actual field names. Note that in this case I declared the lngRecordID variable at the top of the module, not...
Forum: General 02-13-2017, 06:20 AM
Replies: 9
Views: 581
Posted By Beetle
Re: Trying to release a database lock

You need to do both, split the database and set correct permissions for each user.
Forum: Access Web 02-12-2017, 11:57 AM
Replies: 4
Views: 1,764
Posted By Beetle
Re: Web Database Subfiorm/ComboBox issue

Yes, users who do not have the full version of Access installed can use what is known as the Runtime version. This is (in most cases) a free download that can be installed on a client's machine so...
Forum: Modules & VBA 02-12-2017, 11:43 AM
Replies: 1
Views: 256
Posted By Beetle
Re: Help with speeding up code that reads data from excel

Have you considered either linking the excel file as a table, or importing the excel data into a temporary table, then using queries to remove the garbage and/or select only the data you want. The...
Forum: Forms 02-11-2017, 04:42 PM
Replies: 32
Views: 1,164
Posted By Beetle
Re: Function DLookup

You are returning a currency data type from the table. Why are you trying to use a Date format on that value?
Forum: Reports 02-11-2017, 02:06 PM
Replies: 2
Views: 521
Posted By Beetle
Re: Mistake with Reports

From the new db, go to External Data / Access. Select Import tables, queries...., browse to the location of the older db, then import the updated reports.
Forum: General 11-17-2015, 12:01 PM
Replies: 3
Views: 414
Posted By Beetle
Re: Stop Distribution

You might try looking here (http://www.granite.ab.ca/access/demo.htm). The page is rather dated, but you may still find a few helpful ideas there. Keep in mind that if someone is determined and has a...
Showing results 1 to 25 of 443

Forum Jump

All times are GMT -8. The time now is 10:44 PM.

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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World