Search results

Hi I want to check the 16 inputs of a device we have. Each of these inputs are stored in a single row in the DB at the moment. The way I had wanted to do it was similar to below; Increase = 1 InboxMeterP(Increase) = rs2!InboxMeterSerialP(Increase) Increase =...

Brilliant thanks for you help, got it all sorted and working now, well that part anyway, now for the rest of it lol Thanks again

Brilliant thanks working nicely now thank you. Just one last thing, I have changed the OboxRecNo to a variable set from outside the query and that is working fine, but how can I do the same with the date, as it wont always be Date? thanks

Works fine in SqlYog, but when run in Access comes up with the error Data type mismatch in criteria expression still.

Thanks, that solved that problem, but now have a different problem. When I run it with that change in place, I then get a Circular reference caused by alias 'InboxRecNo' in query definitions SELECT list. I chanded it to InboxRecNo1 and at the end of the query as well as below and then...

Hi, I have the following query which runs fine when I run it through SqlYog and returns what I am looking for. Set rs2 = db.OpenRecordset("SELECT * FROM inboxvalues_v2 INNER JOIN (SELECT MAX(InBoxRecNo)InBoxRecNo FROM inboxvalues_v2 i WHERE InboxOboxRecno = 645 AND InboxDateTime <...

In excel it was fairly simple, I had a front page with 2 text boxes. The first one you enter the device serial number, then press a button. It finds the serial number from a list on another sheet, if it finds it, it returns the value of the MAC Address, if not if finds the next available MAC...

I could do with a little help, the solution is going to be so simple, but at the moment I am having a mental block and cannot think how to get past this really simple problem. I have a table with a list of MAC Addresses in it, 4 fields ID | MACAddress | Issued | DeviceID I have another...

It will be used for recording and processing orders, then the fieldworks jobs associated with it. An order is created in tblOrders Part of that order information will be how many meters are to be connected. This could be between 1 & ?????. It then needs to create an entry in tblMeters...

can this be set only allow x number of entries?

Hi, I need to create a form that will allow the user to enter details about say a water meter - make, model, size for example. These will be from combo boxes. Each time the form is opened though, there could be a different number of meters to enter, from 1 to xxxxx I will need to...

What I am planning on doing is adding some extra functionality to the Access DB in as much as when stock is issued through the system, as well as updating the Access tbl with where the stock has gone, new fields are going to be added to the other DB's that I will be getting Access to update as...

There are no users as such with the 2 existing DB's. They are there to allow the devices, which are data loggers to transmit and receive their data. My access system was set up as a stand alone stock and job management system. Due to many reasons, too many to go into now, it needs to be...

Hi I am sure there is a simple way to do this, but I cant for the life of me think what it is. I have a table in my DB called, devices. This contains all the information about various devices we have deployed in the field. These devices are also contained in 2 other separate MySQL DB's...

I have an array formula in a sheet, which looks through a table of data to find the MAX value from this data, if a serial number matches a serial number for that particular site. The formula itself works absolutely fine and returns the correct value. The problem I have having is when I try and...

That's intentional, I have just narrowed it down on the Access one for the moment to a single board so it returns quicker, than having to trawl through just over a thousand boards.

The first one doesn't have the table name on it as it isn't pulling the serial number from the osirisbox table with it.

I have a query which I run in SqlYog at the moment, which is below, what it does is return the last values for each we have deployed in the field. SELECT inboxoboxrecno, inboxmeterserialp1, inboxmeterserialp2, SUBSTRING_INDEX(SUBSTRING_INDEX(inboxmeterp1,":",1),":",-1) AS Meter1...

Ok, I'll confess you've lost me there now lol

Yeah I prefix everything, makes life a lot easier to find when you need it I find, and stops the problem that you highlighted.