Search results

Thanks again. That fixed it for me! As a matter of interest, do you know of a reference article where I can learn how to construct these for different types, ie. strings, dates etc? I always get stuck on this and would like to learn it myself rather than keep bugging people for help!! Cheers

Thanks for that - it works. It did however create another issue. The same "StockItem" may occur more than once in the table but from different suppliers. How do I add and "supplier" to the expression where "supplier" is a string and is also a field in the query? Sorry, but I always have...

Hi Folks I am trying to use a query field as criteria for a dlookup expression within the same query but am having trouble with it! What I have is: StockNo: DLookUp("StockNumber","tblStock","[StockItem]= " & [StockItem]) Where StockItem is a string. Would appreciate some assistance as this...

Thanks again. works a treat!

Hi Folks Could someone please assist me with this. I cannot get the correct syntax! MyLatestDate is Date Supplier is String StockItem = String I am trying to: Dlookup ("StockNumber","TblStock",Supplier = Supplier and StockItem = StockItem and DateAdded = MyLatestDate) Many thanks

Fabulous, just what I need. Thank you again!!

Thank you for the response. I don't quite get what you mean by this. Could you please expand this a bit when you say add the table to a form and do the formatting there.

Hi Is it possible to format the text of a single record in a table? I have an undo function which deletes the most recent record added. I realised from an audit perspective that it would be better to add a status to each record, either current or deleted while still leaving the record in the...

Hi again Sorry for the slow response. I only just the chance to get back to this! All is working perfectly now and this has proved to be really useful in my application. When you say that "you can Refresh it (gobjRibbon.Invalidate)." does this reset the comobox to it's original state and if...

Hi again I have made some progress with this but a couple of issues. I have modified your code in uSysRibbons to include all the other items I currently have on my custom ribbon and to delete those that show in your example which I don't need. All good and works perfectly in your sample db. I...

Thanks for this. I will have a look when I get a chance tomorrow. Appreciate your help.

Hi I have a custom ribbon on which I am trying to place a combobox to enable selection of various reports. To date I have managed to create the appropriate combobox using the following code: <tab id="Reports" label="Reports"> <group id="Group23" label="Reports"> <comboBox...

Thanks again. That worked really well with what I needed. Cheers

Hi Would appreciate a bit of help with this. I am trying to determine the value of a field in a datasheet sub form when I click on that item in the form. To date I have: MyStockNumber = Forms!frmInventoryAdd!FrmInvAddPricesSubForm!StockNumber That is not necessarily selecting the current...

Thanks all for the help. This is just what I needed. This is so much simpler than creating update queries all the time! Looks like I will be able to tidy up quite a few areas of my application by using this. Cheers

Hi again Over the past 18 months or so I have been gradually developing Access/VBA skills, all of which have been self taught or with a lot of help from this forum! I am now at a stage where I would like to be able to write SQL statements but am struggling a bit. My main issue seems to be with...

Hi I have a query that includes a number of defined calculations, such as "TotalCost: [Quantity]*[UnitCost]", and " MyYear: DatePart("yyyy",[Date1])". I am trying to build another query based on the first, using these fields as criteria in a dsum and dcount expression. My first question is...

Sorry Micron I solved this by simply displaying the invoice attachment in the sub form which works just as well. Sometime I just try to make things too complicated!!! Many thanks for you reply. I do appreciate it, Cheers

Basically what I am trying to do is this. I link the forms by maintenanceitem as it will have many instances of repair, all of which I want to display on the subform. The main form is filtered by this field. Each record on the main form may or may not have an attachment (repair invoice pdf)...

Hi I have a form that tracks repairs to equipment and a sub form (datasheet) which displays all the various repairs to a particular item of equipment. I am trying to have the main form update when the user clicks on a line in the sub form. The main form and sub form are linked by a field...