Search results

Thank you again. Just what I needed:)

Sorry to trouble you again, Further to above post, I have added to the change event which makes the list box visible immediately under the text box as soon as the user starts entering data. I need to set the visible property to false if the user continues to type and the listbox is empty, i.e...

Thank you so much - that is brilliant and works exactly how I needed it to!!

Hi Is it possible to use wildcard criteria based on a form field? I am trying to ensure that users do not enter a new item into a table by entering a similar but slightly different description. For example, "Large Beef & Potato Pie" may already be in the table but I want to at least alert the...

Thank you everyone for your help. Everything sorted now and really happy with the results! Cheers

Hi Folks Sorry to trouble you again but this form of coding is definitely not my thing! I have managed to add 1 tab and 2 groups so far and all is working successfully as per the following: <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon...

Thank you all I copied and pasted your statement and it now works fine! Not really sure why but much appreciated!

Thanks for that but same issue!

Hi I am trying to create custom ribbons for my application in access 365. I have tried the following XML in my UsysRibbons table which I used in other applications some time ago. <customUI xmlns="http://schemas.microsoft.com /office/2006/01/customui"> <ribbon startFromScratch="false">...

I hadn't tried it yet as I did not know the syntax. I tried your suggestion and it worked perfectly. Thank you for your help, much appreciated

This may not be logical, but can you use a field from within a query as criteria in a dsum expression in the same query? This is the expression I currently use: This Week: DSum("Quantity","QryStockOutGroup","[MyWeek] = Forms!FrmStockOutGroup!MyWeek And [MyYear] = Forms!FrmStockOutGroup!MyYear...

Hi I have an application that has many forms. I am trying to standardise the appearance (formatting) of each form. Rather than run the new code in each form I have created a table with the new formatting for each object. (I did this to allow for any future changes in just one location). I...

Thank you all. Quite right June7, this fixed it for me. Much appreciated

It is the line StockNo = DLookup("StockNumber", "tblStock", "StockItem =" & "'" & [StockItem] & "'" _ And "[Dateadded]= #" & [MyLatestDate] & "#")

Thanks for the response. It is showing 12:00:00am

Hi folks, I am sure this really simple but I just can't seem to find what is wrong here. The following code is creating an error 13 message. Strangely though, variables MyLatestDate and StockItem are returning the correct values. It is only the Dlookup where I am struggling. Private Sub...

Thank you so much folks for your assistance and patience. A rookie mistake I know but I guess this is how you learn. You have been great!

I hadn't even got that far to test that button yet! I noticed the problem before testing that. If you just do this, open the form, change the value of GST_Applicable, click on Add_Record and do nothing else it creates a record in the table with just that field added. That is what I am trying to...

I hope this works. The exit button for the form will not but close does. Sorry but I do not have WinZip.

How do I upload the stripped down version?