Recent content by Rowey

Rogers Access Blog is a great site too.

Thats it MajP!! The DMax method with error trapping solves the problem - thanks very much. I love a quick and simple solution.

you cant convert an existing number field to an autonumber field. The FW is a concatted text field. The existing number field is the unique ID and all the related tables use this number field.

Thanks theDBguy The problem is that they have all there parts labeled in three stores and the unique Part ID sequence also needs to be maintained. Creating an autonumber field will mean a change to all the existing part numbers.

Hi All - I hope I am in the right area for this. I have a parts database for which the initial data was was originally held in an excel spreadsheet. The existing parts ID had a text(alpha) prefix (eg FW2327). In order to maintain the sequence which was insisted upon, I built an unbound form to...

Thanks Isladog - I fixed it by filtering on SaleDate: Format([DateSold],"Short Date") to remove the time component which I needed for the transaction log. I was surprised because I didn't realise after all these years of using Access that the time component was considered in the query in that...

Hi everyone - please see attached file Warehouse.accdb I have a form that calls a query in the subform to filter on a range of records between the "From Date" and the "To Date" fields of the form. I cant figure out why the query is not returning two records for the 28/02/2019 when the From...

I'm embarrassed. I knew it was something like that but was blinded by my own expectation that it was some glitch!!:banghead: Thanks essaytee.

Hi all Can any one work out what is happenning with the "GetSplitQry" query result for "Pbox 102" and "Pbox 98" in the attached database. It has me stumped. Thans Brice

Thanks CJ_London - as a newbie with less than 10 posts I couldn't attach links. This post has said everything and more than I was trying to articulate.

Hi Sumdumgai In the TS setup I am referring to, the BE (data tables in a separate ACCDB file) are placed in a shared folder on the Terminal server. You can control access to this folder and its files through a windows security group. The FE (forms, queries, reports and code modules in an...

Yes Pat is right - I have tried the VPN route also and it is way too slow. I currently have one clients application located on hired TS and costs them $200 month for 3 users of 5 possible users for that price which is the cheapest price I could find. The performance is very good though as the FE...

Thanks RuraGuy - I have already benefited from being a member, and hope that I can be a benefit to others. Great forum - just what I have been looking for. :):)

In the scenario I spoke about, the front end of the application (forms,code modules etc) are stored in the profile of each TS user, and the back end ( either access or sqlServer tables) is resident in a shared network folder either on the server or a network attached device. As The Doc Man...

Sorry just realised I didn’t mark as SOLVED