Search results

Problem resolved Hi, As the database was in use at a remote location, it made it difficult to solve the problem remotely. As it happens their IT guy was appointed to do some maintenace work and the problem was mentioned to him. It turns out that he seems to know Access really well too. The...

Thanks for the info.... Rather than trying to fix the registry entries, do you think it's now best to uninstall / reinstall Access to try to get the registry returned to its correct settings?? Thanks again DAz.

Thanks for your thoughts... question: When the new host PC was put in place and the database installed on to it the database worked perfectly for 2-3 days. Then after the profile password was created, the database became inoperable only on the HOST pc. the other networked pc continued and still...

a bit more info I had read a previous post about the references which recommended remove and reapplying them. So I removed all references on the host machine and then reapplied them to match the main development version on my PC. This made no difference. Also: The database is hosted on this...

Hi Guys, I have spent many nights and days on this forum, learning about Access. With the community help, examples and problems solved, I finally managed to complete a Database that runs a charity stock control and sales function. Currently it is used by 3 users over a network. A central PC...

Hi Guys, I have spent many nights and days on this forum, learning about Access. With the community help, examples and problems solved, I finally managed to complete a Database that runs a charity stock control and sales function. Currently it is used by 3 users over a network. A central PC...

Success Hi, I spent a little longer with the ID automation font, it seems that the thermal printer could not cope with the font in small font sizes. Because our barcode was going to 15 chrs, I had to reduce the font size to fit it on the label. That was the problem. I sent a smaller number...

Many thanks. I'll try this one and let you know. Daz.

Hi RG, Thanks for your quick response. That was the first thing I tried, admitedly the quality got better and there are more tools for config'ing the printer, but none of the changes seems to make enough of difference to the label quality. coincidently, the printer works fine from a bespoke...

Hi, I am using the downloaded "IDAutomation code 39" font recommended in this forum. It works great on laser quality reports and the scanner reads the codes fine. But when I try to print to a Zebra TLP2844, the labels are intermittently faint, and not readable by the scanner. The whole label's...

Hi, I have a table with pk- Index that stores customer details. I have a second table that stores the items sold, description, barcode number, sale price and discount. On the main Invoice form, that is linked to qrySalesInvoice, the customer records are displayed/updated by telephone operator...

I have similar problem... My problems was that users were going to the Last record using the navigation buttons. When they clicked "Next" button a new record would be created and they could create limitless new records, this was resulting in loads of empty records being created. I manually...

Think I have something that works for me Select Case rs![Command] ' Go to another switchboard. Case conCmdGotoSwitchboard If User.UserLevel = 4 And SetupID = 1 Then MsgBox "Not Authorised", vbOKOnly, "Authorisation Required" Me.Filter...

Slight change of plan After further investigation, it appears that the two charities are more disimilar than I thought. Most of the tables/queries/forms and reports have had to be tweaked to comply with the new charity's business practices. Hence I have created copies of all major structures...

I was heading down the road of global variables. I had created a public variable something like "company=Inputmsg("Company 1 or 2"). Put this in the OnLoad event. This works with the main switchboard form, but fails when i try to refer to it for opening the next form with the filter based on...

Hi, I have a database that controls donations for a Charity. There is to be a sister charity added to the database and a lot of the previously created objects can be used to provide for the new Charity. My idea was to create a "company" ID and label the categories of the donations. I could then...

Hi, I have a data entry form that needs to become an invoice form. The problem I have is that the background colour prints too, tried "print data only" option, but as it says on the tin, only the data is printed. Ideally I want the formatting, field headings, but not the background colour. Is...

Progress - Switchboard wont run VBA code I have found the cause of the hanging application. DoCmd.Echo False, "Compiling Data......" needs to be turned back to TRUE DoCmd.Echo False, "Compiling Data......" THis now allows the report to run. But the strange thing is that I cannot get...

Thanks for the help, I have now done away with accessing the macro and I am running all queries within VBA. I can see that the queries are running as expected. But the report is still being created and seeming to hang the application. Any more ideas please? daz

I have a report that i need user input to decide whether report should be recompiled. The data source is the result of a make-table query and 9 other appends to collate the records in one table for analysis. This needs to be done monthly, so I modified the help-sample script below to ask if the...