Search:

Thanks both. I tried your method Cronk, and was getting errors, eventually I got the button to open a subform which is linked to the main table, so the user can enter the relevant data. This worked...

Because we have to use small envelopes, which Office doesn't recognize, I am having to create labels. I have to send test bars out regularly, and this information needs to be on the envelope. I have...

Sorry if I sound a bit dumb, but how do I assign it. It's a while since I created this database, and then I had help from the kind people on this forum. I understand what's happening in the code I...

I have this code in a form on a database:-


InputBendCert:
strMessage = InputBox("Enter Angle Bend Cert if applicable", "Angle Bend Cert")
If strMessage = "" Then
intNewItem =...

Years ago, with the help of this forum, I created a database, for recording mechanical test releases. I used a report to print DL sized envelope, which in turn used a query to print just the records...

I have created a simple query for a report, which displays all the results I need. What I want to do, is for the query to show the last working days figures, so if I run the report Tuesday, I get...

Thanks Rory. I thought you could only use 1 delimiter. I'll check again.

I created a text file of mp3's, which I want to put into a spreadsheet. The strings consist of artist-song(playing time). When pasting the playlist into the spreadsheet, I pasted as plain text and...

Penny's just dropped. They're rounding up to 100%. Everything's fine now.

I have a pie chart in a presentation, which was created some years ago. It has only 3 slices, with data of 10,10, and 80. The format is percent. Double clicking on the pie chart, brings up the...

Here you are. I've stripped the unnecessary bits.

29020 29021

The green highlighted area is the area that I complete at the moment. Some ops are set, like op1 for Small Commercial, will always be 5. Others are multiplied by the time in the...

I have a spreadsheet which I enter data based on three criteria. How long an operation takes, and how many there are. The third criteria comes in when deciding where the 'how long' comes from. We...

OK. I messed around with the query, as I couldn't find where the f_intIndex was causing the problem, and got it to give me the results I wanted, and ran it through the SQL formatter. The last line of...

Unfortunately, 'name' is one of the fields from an linked table. I'm not getting any errors from the module now, even though a couple of the control names have changed. Now I get 'Compile...

Thanks John. That worked.

Finally sussed it. A missing 'space' between " and From on strSQL2, seems to have done the trick. Thanks for all your help and patience.

I did as you suggested John, and got the SQL in a query, and amended it until it was working (I actually needed to put an extra field in qryEfacs4. In the query, it worked, but when I pasted the code...

I put Debug.Print strSQL2 just before Set rs = db.OpenRecordset(strSQL, dbOpenDynaset), and all it does is prints the line of code. I've never used Debug.print before. Am I doing it wrong?

Not really. There's only the Order No in the query for the main form that's relevant. I did put more fields in the query to filter the records, but where say an order had 3 line entries, as well as...

I have a form (Orders) created from a query which just gives me order numbers. I have a subform (details), from another query which gives me the order details. I have a criteria on this query, which...

Thanks John. I'll give that a try when I get a minute, and I'll let you know what happens.

I have this code in a module


c Sub FillInFields2(strCofNo As String, Optional intIndex As Integer = 1)
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
...

Thanks John. That worked perfectly.

I have some id numbers in a table, which are in the format of S58/1-6. The number before the "/", could be longer or shorter. I want to extract just the text before the "-", so I put this in a field...