Search results

Hi again! The parent dialog has a few text fields for user entry and although these are saved to a table, other fields on the form are calculated values based on that user data (that aren't and because they are calculated do not need to be stored). It is one of these calculated values in a text...

Hi I have a report that runs from a dialog where the user has the option to print out or preview. This has worked fine for many months. Yesterday i had reason to change a label on the report , to a text box whose control source is a text box on the parent dialog from where the report is...

Once again, you sir .... are a ledge(end)... thank you

Looks good... however, when I attempt to reference this routine in the Shortcut Menu Bar property on the report, the dropdown displays empty. If I type the routine name : myPrintReportShortcut, when I run, it errors saying : cannot find the object 'myPrintReportShortcut'...?

I have used a Custom context menu elsewhere in my project (have done so on a form) . I have used similar code that is called on the mouseup() event of the report in question but the default Shortcut menu still displays...?

I have a report that is initiated from a dialog box. From commandbuttons on the dialog - I can preview or print (my own print function). When the user prints the form I need to run some additional code.... However, if the user previews the form and then runs the Print option from the context...

I have a query that uses the following LIKE condition... Like [Search for OD?] & "*" This returns all items where the OD(Outer diameter of components) broadly matches the search criteria. However, my stock of components has sizes : 16mm and also 160mm... If my query search string is '16'...

======================================= Update: I have moved the call to my routine to the very bottom of the Current event() and it is now working.. cant see why at present.....

Move the focus to another record: BeforeUpdate (form) AfterUpdate (form) Exit (control2) LostFocus (control2) Current (form) But when I put a breakpoint in the current event and move focus to an existing record- inspecting the bound control value, value is NULL 🤔

I have a form with a collection of bound controls. By default, the form loads empty for new record entry but using the navigation buttons can browse historical records. I have a text control bound to the primary key / ID for this form and if this is NOT NULL ie. an existing record, I wish to run...

That's a great help - thank you. Nice interface too....

The strange thing is, when I run it .. the 'DateUpdated' timestamps given for forms and reports appear to be for when I last acccessed them and not when I made deisgn changes to the objects themselves..... 🤔 In the example below, I havent knowingly/intentionally changed this form since end of...

Thanks both of you - I now have a routine I can run on any of the main object types - because of the similarity in the two date fields - (presumably on account of when I recently copied the database over to my devt. laptop), I have had to add this condition to weed out the tables I have worked...

Thanks CJ. The TableDefs collection only appears to have : DateCreated and LastUpdated properties.. .. but when I loop through the timestamp differences are very small , only a few seconds... However, if I inspect a table I know has changed from the main Design panel in the main window (right...

Yes - perhaps an oversight on my part(including the single quotes as I did) ... but pretty sure that will work.

Thanks, I found this worked for me... (txtContract & " '' ") ' using single quotes

Is there a way to determine across the entire database what entities (tables/reports/ forms etc.) have changed since a specific date..? I am not talking about records at table level... I mean VBA code and database design/structure changes I am not using source code control or anything...

I am constructing an SQL string in code and am using the following to detect where a String contract reference is NULL / not stated - in which case I use empty string parentheses .. Nz(txtContract, " '' ") .. However, when the string is constructed the parentheses are being removed and I am...

Thanks for the reply CJ and Pat.. as i had already to alluded in my response to Plog, i am doing the single table solution that of course makes the most sense.. i was too blinkered yesterday with everything going on and all , to see it for myself.

I hear what you are saying , essentially you are right. Nevertheless the stock quantities cannot be 100% relied upon so i figured this would be a reasonable way of ensuring some means of recovery in the event that i issue stock that in all reality doesn't exist ... I am not fixing an unsound...