Search results

Hi both, Many thanks for your very quick responses. That code works, thank you! Best wishes, Pete

Hello everyone, Our company database has a facility to add a folder containing pictures or files of any inventory items we keep. There's a button in the appropriate form that has an "on click" command to check to see if there's any folder in the appropriate place for the numbered inventory...

Thank you once again for your help.

Thanks for that, arnelgp. Will the bit Nz(txtSupportContractID,0) not return a zero when there is no SupportContractID? This won't happen, as there won't be a line in the subform when there is no Support Contract. What I'm after is counting the number of visits, but returning a zero when there...

Actually, I think I've answered my own question: =Nz(DCount("*","tblSupportContractVisits","[SupportContractVisitTypeID]=1 AND [SupportContractID] = txtSupportContractID"),0) seems to work. Does that look right to you experts? Pete

Good morning, I'm tying myself up in knots trying to count the number of records that match two criteria to be displayed in a subform. I appreciate that there are similar questions on this forum, but I can't find something that matches what I'm trying to do, hence I've asked here. Thank you for...

Just dropping back in to say that the issue seems to be resolved. The person who assists with our IT stuff has set up an entirely new Hamachi network for us. Apparently the original connection was via Mesh and he has changed it to something else (Gateway?). This appears to work through Eduroam...

Thank you for taking the time to look at this, Doc Man. Food for thought. As a first step I will ask the boss to check the server setup and see if that gives us any further idea of what's happening.

Thank you, Gasman. I can open the folder with file explorer I assume you mean I should do this from work (via Eduroam)? I can ping the computer from home without issue and open the folder to view files on his laptop.

Hi George, and thank you. I will try when I'm next on site - currently I'm working from home, so I'm unable to replicate the issues.

Hello, Yes, ok, apologies. I don't know enough about Eduroam to supply much detail, but it is an international WiFi internet service within Universities/higher education. Access will start (the front end is on my laptop), but the first page of the database does not load, so it's not possible...

I have been running the company database for the last few years. We have a split database with the tables located on a laptop connected to a router in my boss's house, while each user has a front end on their own computer. Connection into to the tables is via a free Hamachi VPN client. As we...

Thank you for the explanation of the reason for the syntax error and for the above. I appreciate there is a LOT of data in the listbox - my boss likes to be able to see everything at the same time! You will appreciate that the listbox font size has to be very small.

Thank you very much for this. It works for me, and it's also nice and simple to follow.

I'm not familiar with this approach. Could you expand, please?

Hello everyone. Hoping this wasn't covered elsewhere. I have a listbox in a database form, which shows all products in the database according to various search criteria. Currently, the rowsource is based on an underlying query, ordered by several different things (Supplier name, Product ID...

Hi Pat, and thank you for your reply to my question. I'd been reluctant to use currency, because due to the international nature of our business, we deal with dollars, pounds and euros, and the currency seems to default to my local currency (GBP) if I set the datatype to currency. I had not...

Many thanks both for taking the time to reply. I think I've been regarding the numbers as a kind of numerical string, rather than considering the issues with storing them. I appreciate your help. Pete

Good morning. I'm looking to provide totals in a query that has some calculated fields in the following way: If the user has entered a one-off price, use this, otherwise calculate the value based on retail price and dealer discount using the following type of formula: FinalPrice...

First up, thanks to plog and Doc Man for helping with this. I really appreciate your time and effort. I think I've solved it by applying the exact same logic as was discussed in an earlier question I asked in August 2022:oops: This doesn't work: like "*" &...