Search results

Thanks a lot. I was hoping it was tab order but I guess since the tab order matches the order I added the fields, in most cases, that was just the impression I was getting. I think I have a way around what I was trying to do.

This may seem like an odd question, but it's puzzling me. I have the following code behind a button on a form Dim ctl as Control For Each ctl In Me.Controls MsgBox ctl.name Next ctl What I'm curious about is the order in which the fields are cycled through. Is it always...

Yes, they are. This I've come across before and it was always an empty recordset causing the problem. Bingo! the function that sets the month number used a recordset that I'd stupidly called the same thing. Once it has been called Rst is at the last record, hence the error. My god I feel...

Thanks for the reply. In order: I use the same form for the recordset loop in dozens of other places with no issues, which is why it's throwing me that this one keeps failing. I've changed the code as per your suggestion though and now the error 'Item not found in this collection' occurs on line...

I'm hoping someone can explain to me - in a way that, say, an idiot could understand - how Access determines that it has reached the end of a record set? I'm running the following code strSQL = "SELECT PQS_Response_Data.Ownership_Period, PQS_Response_Data.Model_Year, " & _...

Thanks a lot. It didn't come up in the testing that was done but, as one should expect, the first person to use it live has loudly complained about it.

I have a table with bookings in it. Each booking has a Date Out, a Date In and the name of the person involved. I want to produce a report of the number of days each person has a vehicle booked per month. Where I'm running into a problem where a booking crosses from one month to the next. For...

Solved! Thanks for the help, guys. Forgive my knowledge of correct HTML terms, but the text field into which I was trying to input a numbers act as a list and it was necessary to specify into which part of the list the value should be placed. The following code works. Hopefully, it'll help...

Playing with the relevant field, I've found that if I enter a parcel number and then inspect the element before clicking on the <track> button, the properties for the element change from <textarea name="search" class="$" id="search" maxlength-"3000" placeholder="Enter p to 75 Tracking Numbers...

Unfortunately, this gets treated by the site the same way as if no number were entered, so can only assume it isn't entering the value. The link produced is https://www.purolator.com/en/ship-track/tracking-summary.page?submit=true&componentID=1359477580240

HI Minty. I did think of that, since I've built a similar function for translating French to English using Google Translate. In that case, it was as simple as you describe, so I hoped it would be the same here. However, if I use parcel number 331287667017 the link in this case goes from...

Unfortunately Access highlights the line in red immediately after I finish typing.

Thanks for the reply. I did, yes. When I selected 'Inspect Element' for that field the following code was highlighted <textarea name="search" class="$" id="search" maxlength-"3000" placeholder="Enter p to 75 Tracking Numbers / PINs or References" rows="4" cols="40"></textarea> I used the...

Via research on this site and using Google, I've put together a Sub procedure to open the web page for tracking Purolator parcels. However, I'm not having much luck in working out how to input the parcel number to be tracked. By commenting out various lines, I've found that all other lines work...

Much appreciated. I shall give that a try asap. In the interim, I'm using Access 2010, so I'm not limited to just the three conditional formats (currently using nine).

*sigh* As is often the case, after spending Friday trying to resolve this, I hit the <Sumbit> button on this question and immediately thought of another way to approach the problem. I'm posting it in case it helps anyone else. I run the same process to calculate the colour values, the use...

I have a form that opens in 'Continuous Forms' view. I know how to have different text fields appear in different colours, based on the value of one of the text fields. Where I'm getting stuck is on trying to set the colour of all text fields for a given record to the value STORED in one of the...

There's only one front end, as it can be used by many machines, but only one is ever using it at a time. I know this as I'm the only one who uses it.

Thanks. 'Change Request' submitted to the IT support people. Unfortunately, they have been known to drag their feet. We shall see.

I've attached the database I'm testing with. For the macro 'mcrProcesses': 1. Right-click and choose Run - error message 2. Go to Database Tools - Run macro - works 3. Open in design view and click on Run - works The scheduler we're using (from here...