Search results

cbo is jargon for combo box. There is a wealth of information to get you started in the Access help system.

In your cbo properties, set the column width for employee ID to 0".

Forms!lYourMainForm!YourSubForm!YourCmdBtn.enabled = False (or True) If the subform is a continuous form, you will not be able to enable THE command button in one row and simultaneously disable it in another row. To my knowledge, its ONE command button (consequently, one set of properties)...

Nothing worse than a bored novice - that one being me. I made a continuous form bound to one of my tables and added ONE command button to the detail row labeled "Test" and ONE to the header row labeled "Log On". The onclick event for "Test" changes the caption for "Log On" to "Log Off"...

The following will extract each of the 1s and 0s from one string and associate it into the other string as you wanted. To test it, create a form with 2 text boxes, txtInput and txtOutput. Put this code in the afterupdate event for txtInput. The results will appear in txtOutput. Private Sub...

Tally the Days stinej, Check out the attached demo db. Open frmTest1 and click days to your hearts content. Each day's onclick event calls TallyDays which updates the Total Days text box. Be sure to add error checking to TallyDays before you integrate it into your application.

The Northwind application in MS's samples is a good place to start. Lots of forms, queries, forms, etc. I too am a VB "student". I also downloaded many linked DBs from this site, regardless of my interest in the particular problem, just to see and (hopefully) understand the code. This site...

I have a question if I may. Somewhere, likely here or Access VB Help, I gained the impression that to populate a recordset you should: rst.movelast rst.movefirst. Does that only apply to table recordsets, none, all? Thanks for this chance to learn too.

ZMAN2, Look at the attached db1.zip; the function is changed to what you want. Open frmtest2 and try it out. (The function is in the module, "Utilities".) The call for the function and processing of the text boxes is in the onClick event for the command button. Have fun.

No good deed goes unpunished. I played with Newman's function and came up with this. Not a lot of difference except it returns "ERROR" if the number of characters specified is greater than the length of strFind. Public Function TestCharMatch(NbrOfChars, StrSearch As String, strFind As String)...

Oops " AND ("[Residence Location]", _

Using a query, you can isolate all timesheet records for a specific employee, >= to a specified date, with hours not null and not 0, ordered by date.

Try This Fox66, the attached db has a demo form and a "Utility" module containing an elapsed hrs function. It looks a little cleaner (?). Try it. Just open the form and enter your dates/times. The function takes weekend days into account but not hollidays. If you have to go there, my...

Fox66, as a retired Field Service Executive, I can assure you your customers DO NOT measure service delivery time in your "working hours". But if you insist on imposing this measurement on them, your function will have to take a lot into account. You would want to call it with 4 variables...

But why not add the yes/no field(s). I have used this technique in 2 applications and found it VERY usefull. I call them Flags. The SQL statement to clear it/them (after you're finished whatever processing you are doing) is simple and can be done in a public utility module. From my limited...

Jan, if CRLimit is a control on your form, don't declare it as a string. If me.CRLimit <= me.TOTAL_VAT then... The logical evaluation will be accurate if both the values are numbers, not strings, and neither is null. Your "math" will display your table if both values are 0. Do you want that...

I don't know if this will give you an idea or not. I like to use this function to work with split applications: Function locatetables() As String locatetables = DLookup("[tablepath]", "tbltablelocs", "[recno]=1") End Function (This function will "find" the linked _be) In this case, tbltablelocs...

Folling WayneRyan's thought, I don't see where you declare iresponse either. You have a select case statement before the msgbox statement. At that point iresponse has no value - and - you have 2 select case statements and only 1 end select. If you don't intend to act on iresponse (VbYes/VbNo)...

Are you at liberty to modify the form? If so consider placing a hidden text box on the form and iterate through the list box placing the key value in the text box each time you find the row selected. You will then call the report for each selected row, passing the value of the text box to the...

Try this. The only output from this routine is a boolean; so, you don't need to save the results of the look up. All you need to know is, did it hit or not. Dim County_Exists As Boolean County_Exists = true if isnull(DLookup("[COUNTY_NO]", "COUNTY", "[COUNTY_NO] = '" & Me.COUNTY_NO & "'"))...