Search results

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...

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...

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...

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

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 =...

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...

Afternoon People, I am creating a database but i am having a problem in that I have a Service Contract form that I want to color code the dates depending on some expressions, I.E I have a "ACplanned Date" (text box) and a "ACComleted Date" (text box), what I want to do is when a date is...

Good Afternoon, is there a way to transfer data between to active form, here's the problem I have a form called "create job" with a order number in it, if you click a check box a new form opens where it should create a invoice number and automatically have the order number in if from the...

hello, I would like to have a set of images spread out over a form (say a map for computer location) I want to be able to select a certain record and it to show up on the "map" I have tried many different things like drawing a rectangle over the computer image and it to change width and colour...

Hello, I work in a college and I have completed Access 2007 level 1-4 and about to complete the VBA course, Basically what I want is to create is a form with floor plans of my college where you can click on a computer and it will show you they machine name/location etc in a sub query and also be...