Search results

I thought I had it sorted but after following the example I have something wrong. I have not worked with recordsets as I am new to VBA. the code given I have adjusted and ended up with this: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs =...

Thanks, got the idea with the 2nd option. Cheers

I want to add an audit trail to an inventory update form. The form allows the user update cost/sell and quantity. The update is "processed" via a cmdbutton with code that checks Gross Margins etc. I want to add to the code some way of writing the changes to an audit table. I have created a...

thanks rich, that was easier. Cheers

Below is a sub creates two error messages if there is no data to display on a report. What is the best way of stopping the sub before the second error occurs? Thanks Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo Err_Detail_Format_Click If...

Hi, I have need to put a error message and action into some code that runs a report for a day's A/R activity. When I run the code where no activity has taken place (ie in the future or a closed day) I get the error 2427 my code is: Private Sub CmdDailytransactions_Click() On Error GoTo...

I am new to using calendars and have read heaps of useful tips about them here but this has me beat.. I have a calendar in a form and want to run some basic code placing the data value in an unbound text box and then run the query. All the useful tips tell me how to do this and run the code off...

This didn't work! It had another critrea which I have pulled out thats why the extra parentheses was there. this is the sql as it stands now: SELECT Calender.AwayTeamID, [QRY Match Players with debt with Team].[Last Name], [QRY Match Players with debt with Team].[First Name], [QRY Match...

Frustrated! Here is the SQL which works great: SELECT Calender.AwayTeamID, [QRY Match Players with debt with Team].Balance, [QRY Match Players with debt with Team].Name, Calender.DateTime, DateValue([Calender].[DateTime]) AS Newdate FROM [QRY Match Players with debt with Team] INNER JOIN...

great stuff Pat, thanks for that. This will assist me no end. Cheers

cheers Thanks, I'll try it in the morning as It's time to go home here in NZ..

DateValue more questions Thanks Mile-o-phile, I have read up on datevalue and it worked great for a between function but if I wanted to select today's records how can I get this working. I have tried the real basic options but no joy. My between statement that works is: Between...

Anybody point me in the direction of a glossary of functions which has examples. My access help appears not to be very helpful on this. Thanks

I have a long date feild I query against and use a wild card in the time part of a long datetime field. Can I do this and how would it be done? Cheers

I have customer ID that is has an M appended to the beginning and an X appended to the end as it is imported into another database. I now wish to create queries that pulls the data the other way and strip the M & X but not sure how. What can I use with in a query to ignore the M & X. Note the...

I want a form loading data based on what they select from the combo box. I assume I need to add something to the control source sql but unsure how to. the control source line is currently this: SELECT QRYDaysofsports.Time FROM QRYDaysofsports WHERE (((QRYDaysofsports.Day)="Monday")); What can...

What is the simple way of removing duplicate query results where the query has returned the same record because the record is in two of the set criteria. I want to create a mailing list but send one letter even if they show twice. I have tried using first in the totals but this just creates a...

I have 2 databases, I want to share customer data between but both have 3rd party applications running over the top. DB1, I can make full changes to the tables etc but DB2 is locked down and can't open but I can write to it via SQL or link the tables. Any ideas how I can share this data with...

Does anyone have or know of where I can get an access based Point of sale application that I can modify to suit my needs. I am sure this has been done many times so do not need to reinvent the wheel. I need the source code included. Cheers

My database deals with sports team game fixturing. The table calendar has schedules for games where each record shows away teams playing home teams in a time slot. I have written a query to show what team members play in these teams based on that timeslot which is in the calender. My query runs...