Search results for query: *

Hello Group The code below works but if you hit cancel at any time it does not exit the sub, the form just fires up. Any suggestions on how to correct this.. It's probably simple for coders ..but I'm not one. Private Sub Location_AfterUpdate() Dim stDocName As String, cancel As Boolean Dim...

Hello to all When creating a new record and getting to the "txtdescription" textbox field the code below is triggered after update..but then after it checks it wants to check the same field for every record...this will take too long. I want to do just the new record or a record I select and...

This in SQL view is a query that only spots dupes if the dupe is in the same position. I like to expand that to search all positions. As always thanks. SELECT tblTirePosition.[Fleet Number], tblTirePosition.[Right Front], tblTirePosition.[Left Front], tblTirePosition.[Right Rear Inner]...

Hello to all I have a small DB which tracks tires by a number (barcode) stamped on the tire. 1.Barcode (stamped on tire) 2.Location (examples are a truck, in inventory or out for repair). 3.Position (Is the position on the truck...left front, right front....etc). (formname is "frmTPosSide")...

Good evening to all. This code was provide by Tek-Tips "TheAceman1" save me a lot of time and grief. Could I ask if someone could help me modify this code to calculate the number of working days in a given month. For example this month "March" has 24.5 working days, We count sat as a half a...

Hello to all I have a DB at work that tracks tire positions on our trucks by a number stamped on the tire. The code below works like this if the current location is a truck number then a small form pops up with a diagram of the front and rear of a truck (by textboxes) allowing you to go into the...

Hello to all I have a DB that I, and 2 other people use at the job. I'm trying to setup a command button with VB code that upon clicking that cmd button it will change the backcolor of that textbox to whatever I set the color too. The thing is I need the command button to be able to change the...

hello everyone. I have a DB that maintains truck information...such as plate numbers, titles, inspections, so on and so forth. These trucks have a certificate for the amount of weight they can carry. I took all the physical cert's and scanned them. What I want to do is to add these cert's into...

Would anyone know How to calculate Depreciation? We have 72 Trucks all which depreciate differently. what I'm trying to do is start with a $ book value for each truck and then depreciate each truck by a value each month. Lets say that truck #307083 is valued on the books for $20,500.00 and it...

Hello everyone..... I have a "Requisition for buying parts" that prints as a report. The query asks you for the truck number, then your initials , then the vendor and last who requested the parts. On the form there is a Checkbox which needs to be checked "manually" (thats fine) and it will only...

hello Tipsters I have a main form that has a subform...in that subform there is a checkbox whereby the user will click and turn the checkbox to yes or true.. this subform is attached to a report that will only print those items that has a checkbox ..checked off. I want to have the checkbox...

I have a small form that has a few textboxes in the detail part that are controlled by a query. At the form "forms footer" I have a textbox that adds all the textboxes in the detail. The only thing is that if the a textbox is currently blank the textbox in the "form footer" will also be blank...

Hello to all... I have a DB where I'm using a VBYesNO command and I want to change its label from Yes..NO... to something like Dept600 and Dept650 respectfully.. Is there anyway to do this ? Any help or suggestions are appreciated. Thank you JZ Testkitt2

I have a form that runs off a query.. If it returns nothing then the form is blank. Is there any way to trap "no data" and send the user a msg... like there is in a report when there is no data you send the user a msg and then cancel the report. Thanks JZ Testkitt2

Hello to all, I have a small form that right in the middle of the form I insert a subform (related by ss#id). Any way when the form opens the tab order starts at the top and works its way down to the subform. It tabs go once inside the subform but when it reaches the last textbox in the subform...

Hello to All I have a query that has a wild card to search for particular numbers in a database. The thing is that there are 7 fields that may have the number that I'm looking for. For example... Lets say that you give each tire on a truck a number and the truck has 10 tire positions. The...

Hi, I have a spread sheet where I need to set the focus on a button when the spread sheet is open. can anyone help Thank you Testkitt2

I have a query that in the criteria field I use the following: Like [Enter the first few characters to search by: ] & "*" This will show all fields that match anything that starts with what the user types. For example if the field has a vendor named "Universal hoses", all you need to type is...

Good eve to all... I have a query that uses the following criteria: Like [Enter the first few characters to search by: ] & "*" the above allows the user the flexibility of searching with only the first few characters. But if you enter invalid characters the query will return a page with blank...

Hello all... I have several users accessing a DB where there is no real control on how the DB will display the data. What I mean is this... I want every first letter of each word to be in caps. Yes, you can use ">" (without quotes) in the format section.. but that makes everything display in...