Search results

You need two tables to make this work. Table1 License State County Table2 Addresses Once an address is enter, you can instruct user to click on a Search button or something to retrieve all of the licenses in Table1 where State=The address' state Count=The address' county dim...

I have two textboxes which represents a search and replace In these text boxes, I want to allow user to type in "banana " so that it can be replace with "banananospace" It appears that the space after "banana " is always autotrim by Access so the space at the end is trimmed off when the...

If you are too lazy to create the onlick event, I suggest you pay a visit to Mr. MS Excel to help you generate those click events and then change the OpenLazyForm() in the MDB in previous post to something like below so that it can account for form number 100, 2000, etc.... Private Sub...

See the example attached for my lazy way of calling different forms from different button.

You can also create a new query using the same query you have in your question, but filter out the department in your WHERE clause and group by your "A & E" department name For the Department name, maybe use something like SELECT "A & E" as Department, ........ WHERE [Department Name]...

When a book is returned. Let's say, user click on a "Return" button, you can instruct (VBA) the button to 1. Insert a row of that information into your second table 2. Verify that it is there using the some sort of unique id for the current record 3. Delete from the first table if it is in...

I don't know if I fully understand the question, but here is my suggestion. You can always create a field for the SubTotal (visible = false), assuming this is the detail line where "Date Added", "Staff Name", "Problem", "Total Cost", "Date Completed" are displayed. On your subform, let's say...

SELECT * FROM [Carrier Table] WHERE [Carrier Table].Carrier LIKE '*' & [Forms]![frmAddNewCarrier]![tbCarrier] & '*'

You can reset your "StoreFilter" query by doing CurrentDb.QueryDefs("StoreFilter").SQL = "SELECT * FROM tblName"

I am not sure if I understand your post correctly, but here is a suggestion. Get a recordset of the parent record For each parent record, get another set of records (child) and just loop through all of them dim rsParent as recordset dim rsChild as recordset set rsParent =...

I have an Access application that allow user to replace text within a NTEXT field (SQL Express). Unfortunately, I can't do the normal update UPDATE tblDoc SET FieldName= REPLACE(FieldName, '; ', '|') Any advice is truely appreciated. -EZfriend.

I think what you want to do is to copy the current record on form/subform A to form/subform B by inserting into tables instead of forms. You and I probably agree that the form is use for displaying/editing purpose. If the tables are identical, you can detect what's current on the form/subform...

This is why DCrake's suggestion is the best. But your request can be accomplished by... Private Sub chkOne_Click() chKTwo.Value = False chkThree.Value = False txtText = "" If chkOne.Value = True Then txtText = "ONE" End If End Sub Private Sub...

It should be very simple. 1. Create a form with the two text boxes for the date range (txtBeginDate, txtEndDate) 2. Depends on what you want to update. Dim sSQL as String sSQL = "" sSQL = sSQL & "Update Table_Name SET " sSQL = sSQL & "FieldName1 = 'text', " sSQL = sSQL & "FieldName2 =...

How can I PROGRAMATICALLY import a table from one Access database to another? I see a lot of example for import text file, csv, excel, etc, but could not locate one with Access to Access. I know the "manually done" way, of course, but need to automate the process. Thanks a lot in advance...

I have two computers, I was able to use the trick on one of the computer, but I can't get the right-click to come back on one of them. Any further advice? Thanks.

Here is something quick and dirty, assuming that the date will always be 8-digit. Private Function ReturnDate(byval lDateNumber as long) as date ReturnDate= cdate(mid(lDateNumber ,2) & "/" & right(lDateNumber ,2) & "/" & left(lDateNumber,4 )) End Function

Yes, infact that's what I have right now, but it involves creating many select statements for each field. Unless I don't know the UNION query well enough. I thought there could be something easier in the Pivot view, but I couldn't get it to work.

I have a query that returns something like this. Field1 Field2 Field3 -------------------------------- 232 223 344 I want to display it as Field1 232 Field2 223 Field3 344 How can that be done? Please point me to the right direction if you can. Thanks. Note: Field1-3 are...

I have a form that is open as a dialog form. Is there a way to determine what the position of the form is on the screen (not Access windows). Is there a way to check if a user drag the dialog form to a different location on the screen? I want to get the x and y position so that if the user...