Search results

I have a STOCK table which holds unique stock records for materials held in our system- I also have a form on which I can select items from the STOCK table that I wish to 'pick'. Any picked items are added to a temporary table STOCK_TEMP. Initially the picking form is populated with a query...

I'm not sure your understanding of the request. I am trying to add a tooltip to reach row of the listbox. I know Access doesn't work that way.. Hence posting the Api code in the link attached...

I have found code on an excel forum for creating Tooltips in a Listbox control.. but cant get it to compile in Access ... Are there any Access/VBA 'gurus' out there that can use this baseline and modify it to work with Access 365 please..? The code in question is here.. ListBox Row Tooltips...

I don't suppose the ROWS in a listbox control can be adjusted i have multiline text i need to display. If not i suspect the only way around this is to use continuous form display config with a multiline text box ..

I have successfully used a list box in a form inrcorporating a right mouse click event in the list box itself, to toggle the selection of all list items.. The list box is 'Extended' type. Using a similar setup on another form I am writing - when I right click, although the code to Toggle the...

Will see if i i can do that today

Agreed i have added new content since i needed to qualify on the autocentre point you made. The problem has been around for some years but i am only now reminded again if the issues given that i am adding extra functionality in recent weeks... I will import all into a brand new db today and see...

As you can see i thanked the OP for their comment. Why take this aggressive tone? I have been reasonable and sufficiently detailed in what is happening. . As i started the form works fine.. If i add a control, save then load the form... Nothing displays. Are you suggesting adding a control will...

It happens on more than one form and seemingly after i have added further controls ... This is also happening on a report i created only a couple of months ago too... Added extra fields to report on.. run the report... Nothing displays... Only after a compress/compact database does it run...

Thanks for your comment. The form has worked fine for years . Today i simply added a combo to refine my filtering of the results that get loaded to a report and put a breakpoint in the code... Run the form.. nothing..

I am having re-occuring issues with a database that I have been working on for many years. I make changes to the GUI of a form, save and run.. but the form doesnt load... I decompile/recompile without issue. Run again, form wont display... I have had to resort to having a seperate database file...

Thank you very much - that works a treat ... as soon as I read your answer I have seen this result before on other development projects I have worked on and swerved finding a solution.. !

I have tried to replicate using a dummy DB and it works as expected... have you stepped through the code to make sure it is entering the conditional part of your code?

Hope can help - a simple way to illustrate my problem... 1.Create a simple database with a table and a 'short text' field, call it ReqNo 2. Add the following records to the table for ReqNo : 2a334,999,1231,34595 3. Run the following query against this table.. : SELECT Max(ReqNo) AS Expr1 FROM...

Not really, the list will only show unique customer names .. I specifically want checkbox selection as stated... or alternative toggle on/off method as stated actioned from a modal filter form/dialog box...

The primary panel shows work in progress but is busy with many records. I want to give the user the facility to hide certain customers to reduce 'clutter' on the form particularly where certain contacts have been on hold for prolonged periods... The customer Id will be stored with the user...

I wish to create a form for the user to hide customers from a panel. On load, The dialog to do this will populate with checkbox rows according to the number of customers returned from an sql query. Any helpful code snippets to dynamically add the checkbox controls would be appreciated. Thank...

Interestingly, in making a copy of the db with the necessary components to send you a copy... I modified a copy of the report in question - in this new DB file....and ran it with no issues... I have now imported that amended copy into my master DB file and it works... ! So I have fixed the...

i would but proprietary business information contained therein... even putting a copy of the report in a new DB would require carrying over copies of various tables, queries etc.

I have a report that is showing hashes in fields where the content is truncated. I modify the report and change the text box width. I can re-open in Design mode if I chose to after Save. But when i attempt to open the report in Form view, the report wont open.. cursor briefly suggests something...