Recent content by Addyman

A number of ways of doing it. If your naming convention is always used you could try: Private Sub DirectPCombo_Click() Dim cboVal As String Dim stDocName As String cboVal = Me.DirectPCombo.Value Select Case cboVal Case "One" stDocName = "TestOneFrm" Case "OneRpt" stDocName =...

I would NOT recommend that. From how I understand your post, you would have 15 fields in your table, and for each combo box, you would populate it with a query which is pulling back one of those fields? Not good. For a start, what if one lookup has 100 values and one only has 10? You would...

This is not the best idea and not the best data structure. What happens if you need Phone3 or email3 etc.? You need to keep adding fields to your table. Have one table for your Contact (Forename, Surname.....) and have an ID field (an autonumber field would suffice) called ContactID. Then, for...

I'm not sure how you validate at a table level but if your users enter this case number on a form then you can validate their entry in the Text Box they enter the case number in. You could have a button for saving the record and then have something like this: Dim strTest As String strTest =...

No problem Sue, glad I could help :)

If DCount("[Shade Type]", "[Item Master TBL]", "[Shade Type] = " & Me.Shade_Type) > 0 Then This assumes [Shade Type] is a numeric field. If it is text then try: If DCount("[Shade Type]", "[Item Master TBL]", "[Shade Type] = '" & Me.Shade_Type & "'") > 0 Then

I'm not really up on NAS Hardware etc, to be honest, i'm more the software side of things. Maybe Rodmc will come back with some more information.

OK, code and process for updating User FE databases: In your BE database, create a table called tbl_VersionServer, with a text field called VersionNumber. This is where you enter the latest version number of your application. In your FE database, create a local table called tbl_VersionClient...

It's easier than you think. I will post up the code etc. you need in a little while (just heading out of the office for a bit!).

The way I work it is, I have a table in the BE which holds the Master Version number of the application (tbl_VersionServer) and a local table held in the FE which holds the Version number also (tbl_VersionClient). I then place a copy of the FE on the Server / Nas which is the Master version...

YNWA - if you are going down the route of a BE on a NAS and FE on the Users PCs, I have some functionality which allows you to update a 'master' copy of the FE (if changes are required) and it will automatically update the Users FEs the next time they start their FE database. Makes keeping...

OK, I see your issue (I think), if you open up the DHS1501 form after going through your instructions above, I see the same item duplicated, but then if I got record number 2, I see your second item (also duplicated). Without spending a lot of time looking at it or thinking about it, I would...

I'm not sure you can, I've always used HTML format for this type of thing. Can't you use the <br> tag to line break your Body text if you don't want it all on one line?

Are the rows required (the 100 or so) already marked or highlighted in some way in the spreadsheets you receive or does someone have to identify them after you receive them?

Well, I assume your barcode string is a text string, so you need to grab the 5th digit from it, convert it to an integer value and then use this value to determine how many digits to grab from the barcode string (If I have understood correctly). So something like: Dim intLength as integer...