Search results

I have 2 forms, one accessed by password for entering data, the other for data searching and is for general use. When I update the input form with new data and the search form is closed, when I open this form the data is there. Should I input data while the search form is open, this form does...

I add to the SQL Statement as shown, I can not receive any listing when I press button 1 or 2, for button 3 the data displays but is still not sorted. I tried with the DISTINCT in and out of the statement. I also tried with the table name in front of product. Could you please assist further...

I thank you all for assistance provided, my final code is as below and works OK - Private Sub Frame256_AfterUpdate() Dim SQLText, WClause SQLText = "SELECT DISTINCT [ProductID],[Product], [Manufacturer],[ProdComp]FROM T_Product Where ProdComp=" Select Case Me![Frame256] Case 1...

Mile-O-Phile, Thanks for the info. I realised my first error, as I am attemting to limit the list in Combo2. I used Frame266 in the With Me! statement. I have now placed Combo2 in it's place. My list from Combo2 shows nothing, no matter what button I press. Could you please assist for when I...

I am using Access 2000 and trying to make an option group frame for sorting records. When I use the below code, I receive an error message, “Object does not support this property or method” when the code reaches line .RowSource. I would appreciate some advise as to how fix the problem. Kevsim...

Rich, I thank you for your input in attempting to solve my problem. The answer to the problem – There was no problem. It was my own fault believing other people and not checking for myself. It turned out the server they were using was at fault and not Access. kevsim

I have a database written in Access 2000, then converted to Access 97 so others can access. All data input was working OK from all users, until I reached record 7690. The record selector is then Grayed out, if I delete one record, all is OK until I reach record 7690. The database file is 1650KB...

Travis, Thank you for the info, I kept playing and finally came up with the code, it also allows for changing the labels. I also called the routine when the form opens, all works well. Below is the code I used. Private Sub Frame110_AfterUpdate() Dim SQLText, WClause SQLText = "SELECT...

I have a form which is based on a Table called T_Product. There is an unbound ComboBox where I can select a Product record, this works OK. I have now added a field in the T_Product table called ProdComp. The idea of this field, is when I enter data in the product form, I can separate Products...

Using the code below, I transfer a Query to Excel, except it is in Excel 5.0 format, How can I change this for output of Excel 97 or 2000. I would appreciate any assistance. DoCmd.OutputTo acQuery, "Q_FinalData", "MicrosoftExcel(*.xls)", "C:\My Documents\WagesTemplate.xls", True Kevsim

raskew, Thank you for the code, it is much appreciated, I will now try and use it. Best Regards, kevsim

I thank you all for the replies, I note the code is written as a Function, how woud I run the function when I press the command button using the On Click event for the date filtering?

Edtab, Thank you for the info,I tried the code you provided but it did not work, so tried the following. I am using an unbound form with the below code. On the form I have Text Box 0 and Text Box 2, where I enter the dates to sort between. I also have a command button where the below code is in...

I have asked this question before, received some answers, but still can not fathom how to write the code in VB, everything I tried failed. I have a query and want to filter the data by “Date Done”, and using a text box to enter the start date and another to enter the end date. I would appreciate...

Peter Rallings, Thanks for the info, however I am still having problems as the records will still not filter by date. I have attached the latest code, but when it comes to line "Set DateWorkDone", I receive the error, "Invalid use of property". Could you please assist me further. Private Sub...

Using a form with 2 Text boxes, one for Start Date and the other for End Date and a Command button, I wish to sort and view all records when I press the command button after the start and finish dates are entered into the text boxes associated with the query. I would do this using the on click...

I have row C3, then row C7, row C11, row C15, row C19, there is a space of 4 rows for the rows I wish to add. If I was adding all rows C3 to C19, the formula would be =Sum(C3:C19), if I added a row C23, this would automatically adjust the formula making it =Sum(C3:C23). To add the odd rows the...

Oldsoftboss, Thank you for the interest, the attachment would be handy. kevsim

ghudson, I had previously tried what you suggested and it works great outside Access, however, when opened in Access it keeps reverting to the original program. What I did find was, type new, then advance options, type in the file extension, then look for the program you wish to use, select...

ghudson, Thank you for providing the info. I typed the code as follows in the text box with the hyperlink. The code is in the On Click event of the text box- Private Sub Text102_Click() Call Shell("C:\Program Files\Paint Shop Pro 6\PSP.exe C:\My Documents\Special\Photos\Model.jpg"...