Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 31
Search took 0.01 seconds.
Search: Posts Made By: firefighter2045
Forum: Access VBA July 31st, 2009, 07:27 AM
Replies: 2
Views: 2,035
Posted By firefighter2045
The data is located in an Access table

The data is located in an Access table
Forum: Access VBA July 30th, 2009, 02:06 PM
Replies: 2
Views: 2,035
Posted By firefighter2045
Finding a missing number in a series of numbers

I need a method in visual basic to find the first number missing in a series of number.
If the series was 1, 2, 3, 4, 6, 7, 9 I need it to return 5. The series run from 0000 to 9999. If there was no...
Forum: Access VBA August 28th, 2008, 08:14 AM
Replies: 5
Views: 1,319
Posted By firefighter2045
SerranoG this data already comes from a query it...

SerranoG this data already comes from a query it is located in several different tables, and some of it comes from other queries which have to preform some very elaborate math to come up with the...
Forum: Access VBA August 28th, 2008, 07:04 AM
Replies: 5
Views: 1,319
Posted By firefighter2045
SerranoG you are close it is not based off of the...

SerranoG you are close it is not based off of the Priority No. I need the records based on the FabUnit which will run from 1 to 14. The Priority No. is used to sort the fields to determine which...
Forum: Access VBA August 27th, 2008, 08:03 AM
Replies: 5
Views: 1,319
Posted By firefighter2045
Selecting records in a query

I have a query with 5 fields: FabUnit, Priority, GskHours, Balance, and TimeToCMP

What I would like to do is select all the records for each FabUnit sorted ascending by Priority where the sum of...
Forum: Access VBA January 18th, 2008, 04:27 PM
Replies: 13
Views: 2,180
Posted By firefighter2045
Thanks for all your help. I wrote a query to...

Thanks for all your help. I wrote a query to take care of the update right now it works great, but there are not that many records in the table. I think it will be OK though.

Thanks for...
Forum: Access VBA January 18th, 2008, 02:49 PM
Replies: 13
Views: 2,180
Posted By firefighter2045
I changed the Update field of UpDt and also...

I changed the Update field of UpDt and also changed FKFieldName to PartID which is the name of the primary key in MachineParts.

The code is now running, but it is not working.
It loops through...
Forum: Access VBA January 18th, 2008, 11:02 AM
Replies: 13
Views: 2,180
Posted By firefighter2045
I put your code on the OnClose Event of the form...

I put your code on the OnClose Event of the form and I cannot get it to work

I had to change the name of the tables in your code
TableA actually "MachineParts"
TableB actually "MachineService"...
Forum: Access VBA January 17th, 2008, 01:35 PM
Replies: 13
Views: 2,180
Posted By firefighter2045
There is one record in table A and many in table...

There is one record in table A and many in table B.

Thanks for all you help
Forum: Access VBA January 17th, 2008, 11:55 AM
Replies: 2
Views: 1,704
Posted By firefighter2045
When you filter a form it is very similar to...

When you filter a form it is very similar to running the find command botton that is built into access. Once you run the filter though only the records that meet the criteria will be displayed in...
Forum: Access VBA January 17th, 2008, 11:00 AM
Replies: 13
Views: 2,180
Posted By firefighter2045
I woild like to preform the update using VBA, but...

I woild like to preform the update using VBA, but I am not adding records to table A I am modifying the field LastServiceDate for records that allready exist.

Thanks for all your help so far, i...
Forum: Access VBA January 17th, 2008, 09:03 AM
Replies: 13
Views: 2,180
Posted By firefighter2045
Let me try again. I have two tables Table...

Let me try again.

I have two tables
Table A has field LastServiceDate
Table B has field ServiceDate

I have a continues form called ServiceNeeded which is based off of a query which uses Table...
Forum: Access VBA January 17th, 2008, 08:45 AM
Replies: 2
Views: 1,704
Posted By firefighter2045
If you are creating the Command Bottom in a form...

If you are creating the Command Bottom in a form you could instead create a filter operation in VBA based off of a combo box. The filtering code will allow you to find the record you are looking...
Forum: Access VBA January 16th, 2008, 11:56 AM
Replies: 13
Views: 2,180
Posted By firefighter2045
Looping Statement

I think I need to create a looping statement that loops through the records in a form and if there is a date in the Date Complete field then I need it to modify a record to a table based on the...
Forum: Access VBA January 15th, 2008, 10:23 AM
Replies: 4
Views: 1,276
Posted By firefighter2045
Thanks for all the help I did not get it to...

Thanks for all the help

I did not get it to work like I first planed, but I got it to work. I ended up creating two different combo boxes. One which displays the description correctly for all...
Forum: Access VBA January 15th, 2008, 08:41 AM
Replies: 4
Views: 1,276
Posted By firefighter2045
I am not really sure what you mean, but the form...

I am not really sure what you mean, but the form is based off of a table named TubContent. This table has a value called JigID stored in it; the JigID is a primary key in another table which stores...
Forum: Access VBA January 14th, 2008, 01:26 PM
Replies: 4
Views: 1,276
Posted By firefighter2045
Combo Box

I am using a continues form as a sub-form in access. In that form I am trying to use a combo box to display the description of an object bases on its primary key. The problem is that the combo box...
Forum: Access VBA November 9th, 2007, 01:34 PM
Replies: 3
Views: 1,268
Posted By firefighter2045
What is the property field set at in your query? ...

What is the property field set at in your query? If it is not set to short date try setting it to that.
Forum: Access VBA November 8th, 2007, 12:53 PM
Replies: 5
Views: 1,225
Posted By firefighter2045
Greg Thanks for all your help, I think its...

Greg
Thanks for all your help, I think its working now.
:)
Forum: Access VBA November 8th, 2007, 11:01 AM
Replies: 5
Views: 1,225
Posted By firefighter2045
Is there a way to automate this process using VBA...

Is there a way to automate this process using VBA in the On Open Event of the report.

Dim length As Long

length = Forms![Custom Labels]![txtCusPart].SelLength

If length >= 15 Then
With...
Forum: Access VBA November 8th, 2007, 09:31 AM
Replies: 5
Views: 1,225
Posted By firefighter2045
Customizing a reports text properties

I have created a report in MS Access that serves as a shipping label. It contains a customerparts field that varies in length, so if the part# are too long and get cut off because they are longer...
Forum: Access VBA November 6th, 2007, 12:58 PM
Replies: 4
Views: 1,666
Posted By firefighter2045
Thanks for all the help. :)

Thanks for all the help. :)
Forum: Access VBA November 5th, 2007, 10:10 AM
Replies: 4
Views: 1,666
Posted By firefighter2045
I think I asked the question wrong. I need to...

I think I asked the question wrong. I need to know which field had focus just before clicking on another control. I am trying to set up a filtering feature where a user can click on a control...
Forum: Access VBA November 2nd, 2007, 11:59 AM
Replies: 4
Views: 1,666
Posted By firefighter2045
Determining what field has focus?

I am trying to wright an If statement that will do different thing depending on which field in the form has focus. I don't know what code to use to determine which field has focus.
Forum: Access VBA November 2nd, 2007, 10:52 AM
Replies: 4
Views: 4,673
Posted By firefighter2045
Thanks its working fine now. :)

Thanks its working fine now.

:)
Showing results 1 to 25 of 31

 


All times are GMT -4. The time now is 03:35 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.