Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 86
Search took 0.01 seconds.
Search: Posts Made By: NearImpossible
Forum: Modules & VBA 11-06-2019, 08:56 PM
Replies: 14
Views: 242
Posted By NearImpossible
Re: Changing Record Source

After looking at this a little closer, I guess I was looking more for pre-populated field sources from the underlying form vs a different source object.

I was able to make it work using unbound...
Forum: Modules & VBA 11-03-2019, 12:00 PM
Replies: 14
Views: 242
Posted By NearImpossible
Re: Changing Record Source

yes, I wanted to change the Source Object so please forgive my wording as obviously RecordSource refers to something completely different, but as previously Identified by DBguy, Source Object is for...
Forum: Modules & VBA 11-03-2019, 10:46 AM
Replies: 14
Views: 242
Posted By NearImpossible
Changing Record Source

Wondering if someone can point out the obvious as I seem to be missing it more and more lately.

I would like to use the same form for entering notes, however, depending on underlying form that it...
Forum: Macros 10-30-2019, 06:43 PM
Replies: 9
Views: 208
Posted By NearImpossible
Re: Custom Right Click Menu

I put the macro in the wrong spot on the properties :banghead:, its working on the form, however if I add it to a text box, I get the regular Right Click menu.

Ill check out your demo


EDIT: I...
Forum: Macros 10-30-2019, 06:37 PM
Replies: 9
Views: 208
Posted By NearImpossible
Re: Custom Right Click Menu

Could you post that zip file here? Its telling me I need an account to download it.

Here are the screen shots of the macros and form properties, I just used the same names as the tutorial for the...
Forum: Macros 10-30-2019, 06:14 PM
Replies: 9
Views: 208
Posted By NearImpossible
Re: Custom Right Click Menu

That is the story of my life :banghead:
Forum: Macros 10-30-2019, 06:06 PM
Replies: 9
Views: 208
Posted By NearImpossible
Custom Right Click Menu

I am using the full version of access to create my database, however the end users only have the Access Run-Time so there is no Right Clicking.

I followed the steps shown here...
Forum: Reports 10-27-2019, 10:59 AM
Replies: 6
Views: 105
Posted By NearImpossible
Re: Not all records displayed

I just deleted the report, made a blank report and then added each query as as a sub report and its working.

I think originally I used the report wizard to make a report based off the first query...
Forum: Reports 10-27-2019, 10:52 AM
Replies: 6
Views: 105
Posted By NearImpossible
Re: Not all records displayed

No Code running in the back ground




Sub is not linked to the master, they are each populated from their own query, just displayed on 1 page
Forum: Reports 10-27-2019, 10:01 AM
Replies: 6
Views: 105
Posted By NearImpossible
Not all records displayed

I have 2 select queries that run to populate an access report whenever the report is opened.

The first query gathers facility information and the second gathers all sub records for that facility...
Forum: Modules & VBA 10-25-2019, 09:00 AM
Replies: 13
Views: 248
Posted By NearImpossible
Re: Record Search

Figured it out

WillContinue = Not (.NoMatch)
If WillContinue Then
Me.Bookmark = .Bookmark
Else
MsgBox "All records have been...
Forum: Modules & VBA 10-25-2019, 08:43 AM
Replies: 13
Views: 248
Posted By NearImpossible
Re: Record Search

Figured out how to get the "not found message", now just need some guidance on how to display a message once all records have been searched with the .FindNext.

Here's what I have so far


...
Forum: Modules & VBA 10-25-2019, 08:15 AM
Replies: 17
Views: 271
Posted By NearImpossible
Re: Importing Multiple XML in Access from Folder

Sorry for the late response but was traveling yesterday.

Schema data is the structure of the the XML file, i.e. Coding to tell the reading program how to process it.

Depending on how your...
Forum: Modules & VBA 10-24-2019, 08:59 AM
Replies: 17
Views: 271
Posted By NearImpossible
Re: Importing Multiple XML in Access from Folder

does your XML files have schema data?

Try changing acStructureAndData to acAppendData
Forum: Modules & VBA 10-24-2019, 06:53 AM
Replies: 13
Views: 248
Posted By NearImpossible
Re: Record Search

Got it working!!!

I was testing your code in the button on click, however I had my old code on the txt after update so they were conflicting.

I placed your above code, to include the .findnext,...
Forum: Modules & VBA 10-23-2019, 05:07 PM
Replies: 13
Views: 248
Posted By NearImpossible
Re: Record Search

So I tried arnels first posting and no matter what I enter, if it exists or not, it just selects the name field on the first record.

I have these 3 columns setup so no duplicates can exist so I...
Forum: Modules & VBA 10-23-2019, 07:31 AM
Replies: 13
Views: 248
Posted By NearImpossible
Re: Record Search

Can I do a set focus with this setup? Currently once it matches, it selects that field i.e.


"[Serial Number] Like '*" & Me.txt & "*' me.[Serial Number].SetFocus OR " & _...
Forum: Modules & VBA 10-23-2019, 07:25 AM
Replies: 13
Views: 248
Posted By NearImpossible
Re: Record Search

For this one I just want it to go to that record, I do however have another form for a different purpose that filters based on the results, but i'm doing that with an access query.
Forum: Modules & VBA 10-23-2019, 06:41 AM
Replies: 13
Views: 248
Posted By NearImpossible
Record Search

Currently I have some code setup to search a table for a specified string, based on the search criteria of either Serial Number, Asset Tag or Name.

What I would like to do is eliminate the need to...
Forum: Queries 10-19-2019, 06:59 PM
Replies: 5
Views: 106
Posted By NearImpossible
Re: Delete Query Comparing 2 tables

I never get discouraged, I just wasn't finding what I was looking for so thought I would post here as you guys have been a great help on past questions, while I was on the hunt....
Forum: Queries 10-19-2019, 06:11 PM
Replies: 5
Views: 106
Posted By NearImpossible
Re: Delete Query Comparing 2 tables

After a little more searching, I got it to work with the following


DELETE FROM RMAs WHERE NOT EXISTS (SELECT * FROM FacilityEquipment WHERE RMAs.RMAID = FacilityEquipment.[RMA ID]);
Forum: Queries 10-19-2019, 05:44 PM
Replies: 5
Views: 106
Posted By NearImpossible
Re: Delete Query Comparing 2 tables

I tried the following suggestion off of another post but it deleted everything, even though there was a matching ID in the equipment table.

DELETE RMAs
FROM RMAs
INNER JOIN FacilityEquipment
ON...
Forum: Queries 10-19-2019, 05:35 PM
Replies: 5
Views: 106
Posted By NearImpossible
Delete Query Comparing 2 tables

Wondering if someone can help me out on a query...

I have a RMA form containing a RMA table with a RMAID field, Facility Name, Facility Address and Date.

On my Equipment table I have several...
Forum: SQL Server 09-30-2019, 06:57 PM
Replies: 1
Views: 102
Posted By NearImpossible
Re: Write Conflict Error

I figured it out, earlier I was messing with a timestamp field and decided to not use it, however the existing records were affected by it.

I wiped the table and entered new records and everything...
Forum: SQL Server 09-30-2019, 05:50 PM
Replies: 1
Views: 102
Posted By NearImpossible
Write Conflict Error

I have a FacilityNames table with a FacilityID and Facility Name column, I also have a FacilityEquipment Table with several fields and they are related by the FacilityID.

From time to time we need...
Showing results 1 to 25 of 86

 
Forum Jump



All times are GMT -8. The time now is 12:40 PM.


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