Recent content by round

Not the type we use. I've tried re-writing around their newer units and have failed. Was looking for an alternative Thanks

No one? I'm really stuck on this one!...

Sorry I didn't make myself very clear. The WinTV units need replacing and they are no longer available. They have newer versions but they don't use the old ocx. I have been unable to get the new version to work with what we currently have. Thanks

Hello All, I really hope someone can help. We currently have an access database that is used to take pictures and then print to id whilst saving the info about the person. Basically you enter the person detail, click take picture, then click print card and once printed the card is scanned...

Once the mdw file is created how can the db be moved because I get an error saying the file can't be located.

Thanks Doc i have looked into the mentioned items and I got a little lost. As I see it I will need to add all users explicitly?? This could take some time. Is there not a way that all users who access the mdb come in as a standard user? I tried the work group security wizard which created an...

Hello all, I have an mdb that only one user can have open at a time, but the default open is set to shared. Any Ideas? Many Thanks

I found this was an issue with my local profile. I deleted profile let it recreate on logon and problem solved. Many Thanks

Hello The_Doc_man, Sorry I have deleted the duplicate post now. OS: Vista Business sp2 It was originally standard install but re-tried install all ways. I don't have to put disk in for it to load. When I open Access it goes through the whole install process and once it completes access will...

Hello All, I have office 2007 installed and evertime I launch access it goes throught the install process before it opens. I have uninstalled office and re-installed and tried the repair option when re-installing none of which have worked. Any ideas? Many thanks in advance.

Thanks for Mstef I do like your example which has given me some ideas for others sections I have. However after playing around with this I have figured out a solution. I have a added a column to the query that uses the combo box like so: In the field row I have: iif([record_type]="S","Staff...

Hello All, I have a combobox on my form which I have typed two values into (S & C), which corrispond to Staff or Customer. So if I select S I will see staff records. I would really like is to have the combobox to display the two values available as Staff Records & Customer Records rather than...

I ended up using a yes/no field which can be updated via a query and then I used the vb code: DoCmd.RunMacro "update_invoice_raised" as part of the event procedure to call a macro that fires the update query. Worked out quite useful as I was able to have messages pop up explaining what is...

Thanks Khawar but the check box would need to be on a sub form. I have a form which displays customer details then a sub form which scrolls through the transaction records. So the check box would have to go on the sub form so that each individual transaction could have one. Many Thanks

Hello all, I hope someone can help. How do I update a record via an event procedure? I will try to explain...as best I can... In my access db I have a button that will produce (via an event procedure) an invoice/report for a given customer of all transactions to date. What I want to do is...