Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 38
Search took 0.01 seconds.
Search: Posts Made By: T. McConnell
Forum: Forms 11-07-2019, 09:07 PM
Replies: 2
Views: 82
Posted By T. McConnell
Go to and highlight current record in subform

Greetings all again,
I have a form with an unbound subform as I don't want to select just one record in my subform when I am searching.
What I have is on the form is a search record box which...
Forum: Forms 11-03-2019, 02:39 PM
Replies: 4
Views: 200
Posted By T. McConnell
Re: New record created to table if nothing done??

Thanks Pat,
I found I had some code in my OnLoad that was actually causing it ugh lol.
Forum: Forms 11-02-2019, 09:12 PM
Replies: 4
Views: 200
Posted By T. McConnell
New record created to table if nothing done??

So basically I am running into an issue where I have a form to track expenses. When the form loads, instead of having New in my Expense ID field as being a new record, it loads up to the new Auto...
Forum: Forms 10-06-2019, 08:39 AM
Replies: 7
Views: 207
Posted By T. McConnell
Re: How to remove one row/record in a continuous subform

Wanted to do a quick reply back on this one. I have come to a solution that will work for what I am attempting.
Basically I have a subform built off a query including my orders, other order details,...
Forum: Forms 10-05-2019, 09:34 PM
Replies: 7
Views: 207
Posted By T. McConnell
Re: How to remove one row/record in a continuous subform

I tried using this for my delete query, it seems to almost work but I am getting the enter parameter msg when trying to click on the remove button.
The code I am using for the delete query is below,...
Forum: Forms 10-05-2019, 08:03 PM
Replies: 7
Views: 207
Posted By T. McConnell
How to remove one row/record in a continuous subform

Greetings all,
I have a question maybe could get some assistance on. I have a subform that will display parts available based on specific vehicle information (Year/Make/Model) this all works fine....
Forum: Forms 09-30-2019, 02:11 PM
Replies: 9
Views: 192
Posted By T. McConnell
Re: Calculated field behind 1 from quantity?

I was able to get it to work on the LostFocus event of the Quantity Combo box.
I used to code below to make it work, it currently suites the need I am having :)


Private Sub...
Forum: Forms 09-28-2019, 09:27 PM
Replies: 9
Views: 192
Posted By T. McConnell
Re: Calculated field behind 1 from quantity?

Unfortunately that didn't do it :(
I don't see why when the total field that sums everything up changes, I can't get the bound text field to update correctly.
The first pic TotalCostSum is the...
Forum: Forms 09-28-2019, 08:52 PM
Replies: 9
Views: 192
Posted By T. McConnell
Re: Calculated field behind 1 from quantity?

For this particular issue, basically I have a field on the mainform that takes quantity times a set price.
1. Part 1 Quantity * Cost (This is sent to its own unbound text box called txtEstModule)
...
Forum: Forms 09-28-2019, 08:11 PM
Replies: 9
Views: 192
Posted By T. McConnell
Re: Calculated field behind 1 from quantity?

Other problem doing it that way, is I have other fields on the main form based off calculated fields and quantities. When I use the Me.Parent.Recalc method it clears out the subforms total to 0, and...
Forum: Forms 09-28-2019, 08:00 PM
Replies: 9
Views: 192
Posted By T. McConnell
Re: Calculated field behind 1 from quantity?

Would I do this on the afterupdate of the unbound field?
Forum: Forms 09-28-2019, 07:24 PM
Replies: 9
Views: 192
Posted By T. McConnell
Calculated field behind 1 from quantity?

Name is confusing sorry, basically I have a query that takes a cost price and multiplies it by the quantity. I then pass that total to an unbound field that then updates a bound field. Yes I know not...
Forum: Queries 09-21-2019, 08:38 PM
Replies: 3
Views: 128
Posted By T. McConnell
Re: Have to run an append query twice??

PBaldy,
Thank you again for your help. I don't know why I can't remember that bit of code.
You helped greatly!
Forum: Queries 09-21-2019, 08:19 PM
Replies: 3
Views: 128
Posted By T. McConnell
Have to run an append query twice??

Hey all,
I am having an issue I have an append query that is to add new records to a table. The query is tied to a button that checks to see if a checkbox is checked and if so to run the append...
Forum: Forms 09-01-2019, 06:16 PM
Replies: 7
Views: 113
Posted By T. McConnell
Re: Form to show 20 records at a time

Does the form need to be a continuous one in order for this to work as well. When I do so, if I click on the button to it goes to the end of the list and then gives error can't go to that record. If...
Forum: Forms 09-01-2019, 05:42 PM
Replies: 7
Views: 113
Posted By T. McConnell
Re: Form to show 20 records at a time

Micron,
Different screen resolutions are there, but shouldn't be an issue doing that. I was hoping to do it a cleaner way maybe. Thanks for the info though.
Forum: Forms 09-01-2019, 05:04 PM
Replies: 7
Views: 113
Posted By T. McConnell
Form to show 20 records at a time

Hello everyone,
I am looking at the best way to open a form built from a table. In my case a customers table. What I would like to do is on a button it opens a customers form displaying the first 20...
Forum: Forms 08-23-2019, 03:11 PM
Replies: 4
Views: 108
Posted By T. McConnell
Re: search bar for form

Just putting my example that works for me in case it helps any. If it seems off to any of you experts please let me know :) I only want to help and hopefully get better as I go as well.
...
Forum: Forms 08-23-2019, 02:51 PM
Replies: 7
Views: 203
Posted By T. McConnell
Re: Image display as you move through a drop down list

I appreciate the info. With this current setup, I don't have room for a full list box.
What I decided to try and so far it seems to work was I created a Query to display the picture from the...
Forum: Forms 08-22-2019, 07:24 PM
Replies: 7
Views: 203
Posted By T. McConnell
Image display as you move through a drop down list

Greetings all,
I am looking to see if this is even a possibility or not. I have a drop down list for different products. I also have images on a products form where parts are entered into the...
Forum: Forms 07-29-2019, 08:10 AM
Replies: 6
Views: 179
Posted By T. McConnell
Re: Form Validation with multiple selections and/or fields?

Obviously I'm oblivious to some things it seems lol. Thanks for that info, I'll make that change to avoid this.
Forum: Forms 07-28-2019, 05:17 PM
Replies: 6
Views: 179
Posted By T. McConnell
Re: Form Validation with multiple selections and/or fields?

I was able to get it to work using the code below. Thank you both Arnelgp and GinaWhipp. I hadn't tried it on the BeforeUpdate event before getting this to work. I just noticed I had a hard time...
Forum: Forms 07-27-2019, 07:19 PM
Replies: 6
Views: 179
Posted By T. McConnell
Form Validation with multiple selections and/or fields?

Hey everyone, I am need of help once again. Working on a simple expense tracker database. On the form I have two different comboboxes that based on certain selections with make some textfields...
Forum: Forms 07-14-2019, 11:17 AM
Replies: 4
Views: 172
Posted By T. McConnell
Re: Maintain cost after order submitted and price changes??

I have seen numerous posts across different sites that point to a FIFO style setup. My only issue with this is on the order form I am using, only the Product and Quantity fields are visible, so all...
Forum: Forms 07-12-2019, 04:57 PM
Replies: 4
Views: 172
Posted By T. McConnell
Maintain cost after order submitted and price changes??

Sorry for the title, not sure the best way to word it. So my question is for all you experts, (thank you all by the way for everything, ya'll have helped a LOT) I have a two inventory tables with...
Showing results 1 to 25 of 38

 
Forum Jump



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