Search results

Hi, I am trying to email a report based on the current record being viewed in a form. I have this so far but of course when the report is created it has all the records in it. Was wondering how I can create a report for the current record in the form. DoCmd.SendObject acSendReport...

Anybody else have any idea's on this one? :(

Hi namliam thanks for you reply! :) I don't think I explained what I need terribly well.. I will have another go at it. If I have 3 duplicates and of these 3 duplicates, 2 of them have "TRUE" in the "AllowRefund" Column but 1 has "FALSE" I would like all 3 to show.. If I then put a "TRUE" In...

I am creating a database for refund requests.. Sometimes the refund request can be duplicated so I have a query using " In (SELECT [OrderNumber] FROM [tblRefunds] As Tmp GROUP BY [OrderNumber] HAVING Count(*)>1 ) " to identify these duplicates.. I also then have another column called...

Hi, Sorry if this doesn't make sense.. :o Just building a database at the moment that logs conversations. I have one table called job data that holds job info such as job id, start date, end date etc etc.. Then another table linked with a relationship to this called convo data that holds the...

I didn't even know Ctrl+G was a short cut until last night when I was setting up custom short cuts. :rolleyes:

Unfortunately I need to lock it right down..

By disabling access short cuts it also disables Ctrl+G lol...

Hi, I have used a number of ways to lock down my database... 1 Disable Shift on start, 2 used xml to hide the qab and ribbon, 3 used vba to also disable qab and ribbon, 4 disabled access keyboard short cuts etc etc.. Problem is ones I use all these at once how will I be also to access vba editor...

Hi sorry maybe I didn't explain what I'm after very well.. Say I had 2 refunds and 5 payments in 1 day. Need a query that takes each refund and each payment and puts them as individual rows in one field. I can when in one query import the data in to excel.. of course I will just be using the...

Hi I have a table called "table1". within that table I have 2 fields.. "paymentdate" and "refunddate" I need to pull both these fields in to one field to consolidate all payment transactions and refund transactions for the current day in to one field. This data is then to be exported to excel...

Problem is I would want to minus the refunded amount from the original sale.. If it changes the original sale to a refund (minus) I have nothing to refund against!? :confused: Therefore instead of subtracting £50 from £50 to leave me £0 it would leave me -£50.00. Thanks for the idea though.. Is...

Hi, In my database I have a payment amount column and a refund amount column.. I also have a refund required column.. If the refund required column is set to True then I would like to take the payment amount figure (say £50.00) and then place it in the refund amount column as a minus figure...

:p Thanks!

Thanks! I have been racking my brains all night over that! And I cant believe how simple it is now! I will be taking a look at the above URL! Thanks for your help dK! :cool: I'm not in my Partners good books tonight because I have been sat in front of the pc since I got home from work trying to...

Hi, I am currenly using the update query method which works but not exactly how I would like it to perform the task... The as you go method you suggested is how I would like to do it but cant get my head around it.. What would I need to do with the code that you supplied n your first post, so...

Hmmm cant seem to work out the above... This is how my database is structured I have a main database which shall we say is called database1. I then have a form linked to a query like looks for all incomplete records with No in the field (field name "event complete?") Once the user is done with...

Thanks for the quick reply! So when they select Yes in the drop down.. The above will update another field within the record to ****? This specified field is required to make the other info within the record usable. :) Thanks Tom

Hi, Im putting together a database at the moment which hold a lot of confidential details.. The info is submitted to the database and once used yes is selected from a drop down to confirm complete. What I would then like it to do is update a specific field(s) with a for example 4 *'s so the...