Search results

I have a large application with many forms, some of them old. I have noticed that when I add a toggle button to a new form it looks fine, like a button. But when I add the same toggle button to an old form, it looks like a plain rectangle, not a button at all. I don't think that the toggle...

I have code that requires the Microsoft Word 14.0 Object Library. How do I add that? My application is on a remote server and the techs are unsure how to add the library for myself and all of our users. Any suggestions appreciated. Robert

I have an old playsound() function in my code to play wave files with beeps etc. It uses the apisndplaysound function but my latest version of Access does not include that. So I have commented out that code. Is there a function that will play wave files, or can anyone suggest one? Robert

How do I display a Word document or PDF document in Access?

I have a big application with old and new forms. Running Access 2019. When I put a control button onto a new form it looks great and is three dimensional. When I add a new button to an old form, it does not look like a control button at all. It is just a flat rectangle. I have looked at the...

I have a big application with many old and new forms. When I put a button onto a new form, it looks just as you would expect, a button to click on. But on old forms the buttons look like a simple rectangle. If I add a new button to an old form, it looks like a simple rectangle and not like a...

I am using Access 2019. It seemed to be working OK, but now I have two odd things happening in queries: 1. Where I have two tables in the query and there is a link between the two tables, I used to be able to pop up a little command window which said Use all records from table A and joined...

I have an old application which began in Access 2003 or 2010 and it uses many of the old Access 8 item menus. There used to be an icon to enable changes to those menus top left of the screen, but in my new Access 2019 that appears to have gone. How do I access the menu modification utility in...

I have a long established program that was running in Access 2010 with no problems. Now we have moved to Office 365 (which I think is Access 2019) and we have a new problem. The code is 'NumRecs = rsLotBid.RecordCount'. And the word RecordCount comes up with an error, 'Compile error: Type...

I have a long established program which I am in the process of updating to a new server running Office 365. The program appears to run OK. The only problem I have found so far is that to display the opening menu you have to click on 'Enable Content' each time the program is run. I have tried...

I have a large inventory table where every item has a stock number, which is an autonumber. I want to search for the item by stock number and have a number field where the stock number is entered, and that displays a subform with details of that stock item. However it does not work! I get a...

I have a database with about 30 users, and some of those users need tabbed documents to be set, which they do manually every time the database is updated. Is there a way that I can set 'Tabbed documents' in code for those users? I can identify the users. Robert

I have a report which prints a label, but based on a certain criteria, sometimes one of the fields should not be printed. How do I do that? I have tried adding me.myfield = "" in Report Open etc, but then it either does nothing or the report does not print at all. How do I selectively blank or...

I am working on a big application that has been developed over ten years. I have a field that is not getting updated in one of the tables (POLATE) and have no idea where that field should be getting updated. Is there an option to put POLATE into a search and find out where that field is...

I have a selection process for various warehouse locations, which results in a query showing those locations. Now I have to print labels for those locations. I thought the best way to do this is to create a temporary table with the list of selected warehouse locations, and then step through the...

I create barcodes on various forms, and I want to be able to use a barcode scanner to read the barcodes without the need to press 'Enter' after the scan. The barcodes are 6 alphanumeric digits. I have tried using an input mask, like AAAAAA (requires a letter or number), but it just sits there...

I have a report which usually prints to a printer, but sometimes we want it to be in preview mode so that we can make a PDF and email it. I don't want to duplicate the report. Is there a way that I can programably select printer or preview mode? The report is actually a packing list used many...

I have a report that is used to print a packing list. For one class of customer I need to also print a subreport with more information, on the same page. I don't want to duplicate the report for this one change, but am looking for a way to print or not print the subreport, perhaps in code?

I have a query which shows records from a table. Then I have a second table linked by a common field, with a criteria. The criteria that I want to use for a record is that a linked record in the second table is NOT present, OR if it is present, then a field value in that record is 4 or 5. I...

I have two forms that are not linked. A barcode is read on one of the forms and I want to transfer that barcode data to the second form, to avoid having to scan the barcode twice. This works fine as far as it goes. I use IsLoaded to make sure that the second form is loaded, then transfer the...