Search results

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

There is only one record in the report. It prints a label. But based on criteria, one field may not be printed. No problem leaving a blank space on the label. Robert

dbGuy: Thanks for making that clear. The report is actually a label with the fields stacked in boxes. So having one empty box on the label would be no problem at all. Robert

DBguy: I would be happy to make the field invisible. However if I could replace it with something else then so much the better. 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...

DBguy, can you give me the name of that utility or where to get it? It would be very useful. Robert

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...

Yes, I have no problem printing the labels. They are actually 20 labels on a page. What I was looking for was the way to step through records in a table and take action on each record. Thanks. Granville

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...

Missinglinq: Yes, that worked perfectly. Thank you.

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...

DBGuy: How do I set the height of the new subreport to zero? I found the 'can grow' in the detail section, but when I try to set the height there to 0.0" it returns to the number that was previously set. I can make the new subform invisible but it still takes room on the page and sometimes...

Thank you dbguy. That should work!

Thanks dbguy. There are headings etc on the subreport and I don't think I could make it small enough to be invisible to all other customers. I am really looking for code to print or not print the subreport, based on customer type. Robert

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?

Paul: I am not familiar with that. What is it? Robert