Search results

Sorry People, I really did over complicated this didn't I lol here is the new code I dumbed myself down and it worked first time:-) Private Sub Command12_Click() Dim i As Integer Dim answer As Long i = 1 answer = MsgBox("Are you Sure if so please take a " & vbNewLine & [Toner Ref Number] &...

I have a continuous form that shows all the stock from stock table with + - command to add or subtract the quantity when stock is being used or replenished with messages to inform about things, the problem that I am having it that it only looks at the first recordset for any change so if I have...

well I have the machine query that has the location eg. 4d24 and then all the form has the name frm "4d24" though I could do load sub for "frm " & [location]??

Good morning people, here is the scenario, I have a list of computers that are selected by area, floor etc, what I hope to achieve is that to be displayed in the detail and in the form header have a sub form with the layout of the room to show the technicians where each computer is, do you think...

sorry thought my first message explained, I need unbound text boxes to change colour depending if someone is logged onto then, I.e red if they are logged on and green if it's available to to use. if I do conditional formatting you have to have focus on the record before it changes colour, but I...

ok I'll explain more, I have a query with current log ons, lets say 35 people are logged on and 70 machines available in that area, the query lets me know there user name and machine they are on, if I was to hit the "find me a computer" button all the machines that are in the query turn red and...

no as it is only looking at 1 record so 1 machine changes colour, I want it to look up the whole query so multiple records change colour? thanks

thing is I don't need it to be a continuous form all I need on the form is the floor plan with 30-40 textboxes as machines looking up a query, I should point out that the query only shows users logged onto a particular floor.

Afternoon people, I have a "computer Locator" database I want to create where it will show customers where available compters are located, now I have tried conditional formatting and don't really want to type up hundreds/thousands of vba programming to say IF testbox = computer name (example), I...

thanks for the quick responses mate, it is a continuous form which will re-query say every 5 mins (I know how to do that) or on a "Find me a Computer" button, I have done a conditional formatting form previously for a service contract database I design where I had it showing different colours...

lol yeah I know but I guessed I lied when I said Mini Project as it will eventually expand (if I get it to work) to have over 3000 computers with different floors!! in my head it's achievable but I was wondering also If I put ="computer name" and tag all computers on that form can I run a...

well I guess it really doesn't matter, I have in the Form Heading the Floor plans with the box shape not text box hence I can't use conditional formatting and query then runs in the Detail part.

Afternoon, I am trying to do a mini project where I have a map of a floor and a query that has current users that are logged on to computers, what I want to achieve is that if I put box1-10 (computers) they change colors when they are in use or currently free. any help would be much appreciated

lol already done that, thanks anyway

I have locked down the database, they can't access the code, tables etc, but they can delete records for orders, invoices etc, all I know it was working and I was told that they "accidentally" deleted records as they didn't realise it was live data, can you give me an example of dmax() thanks...

Morning people I have a problem with some vba coding, basically I have this code #Private Sub Text6_DblClick(Cancel As Integer) Dim db As DAO.Database Dim rst As DAO.Recordset Dim i As Integer Dim strSQL As String Set dbs = CurrentDb strSQL = "select * from [tbl sale invoices]" Set rst =...

No I was thinking that I would add a field to the logon table "class" and then maybe use a SQL statement to determine a outcome?

Good Morning VBA masters, I have another problem aarrrhhhh, right I have a login screen for a new database I am creating, I have a table called "tbl logon" with the staff members and there passwords I have got this code which works fine if I just want them to close the logon screen and open the...

Good morning, I hope someone can help me? this is my problem I have a piece of coding that I will add of the end that works out the datediff for a order date to current date which works fine, what I want to do is make the records change according to these rule, If < 3 then change green (New...

Good morning people, I have a exsisting database lets call this "old asset db" I am creating a new database "new asset db" I have exported the data fine but what I want to achive is I have a table in the old database called "assets" with a field called "asset number" which is a number and I want...