Recent content by inlanoche

That is True jdraw. the database was a pet project I created when we moved offices to better track staff, seating, phone numbers, and data wiring. Because they liked it so much at my office, they have started to roll it out across Canada (where I am from). Our company spans the globe, and...

The alpha in these cases represents a section of the floor, I believe. The trailing alpha (A-L) represents the fact that they have added/split areas and have no more numbers that they want to use. In one section they have just passed to me, they added about 12 sit/stand desks in a wide...

Thank you for the posts... Just to clarify, my system was created to use the format: Floor-Desknumber Unfortunately, this one office, does not want to use that, and won't change it. So now I am stuck with parsing office numbers with letters mid string. Not desirable, but our Facilities team...

I am still managing a floor plan database for various offices across Canada. All has been well, until one office decided to go against a standard I put forward for office numbering, and wanted to include letters in the seat numbers. So for instance, they have office/desk numbers like 3D01 and...

Ok, I found it... : rs.FindFirst "[BoxNumber] = '" & aBox & "'" The quotes thing is killing me... OK! the whole thing works great now, and again, I thank all that have helped out. Here is the completed code incase anyone else is doing something like this and needs a sample (though I won't...

Thanks JHB, I tried the initial code snippit that you posted, but I think I erred a bit with the code I posted, and it didn't work. So I tried to see if maybe something was typed up bad (from me messing with what you posted)... I think it was the form data. aMainMenu.ThisLocCode.Value, this...

I'm not the best with SQL, thanks. Ok I tried that: Set rs = aDB.OpenRecordset( _ "SELECT * FROM dbo_BoxNumbers WHERE LocCode = " & _ "'Forms!aMainMenu.ThisLocCode'", dbOpenDynaset, dbSeeChanges) now I get the error : Object required

Sorry Dale, not trying to be snooty, and I am greatful for the help. Bad day at work all round. It is frustrating knowing what you want to do, knowing it is possible, but not understanding the syntax. I know I need to take baby steps before leaping in, it's just that the information I have...

I have looked through that (ok not with a fine tooth comb) but I seem to be getting various issues. If I follow what they say there: Set aRS = aDB.OpenRecordset("dbo_BoxNoQuery", dbOpenDynaset) I get the run-time error 3061 - Too few parameters. Expected 1 Looking this up I found that it is due...

I am not planning to add a record to the query, but I don't think you are right if you are stating you cannot change data in a query. I can go into the query dbo_BoxNoQuery and edit the OfficeNumber field. I am trying to automate that process and it will be long and grueling for one office...

from the control source (table called dbo_OfficeListings Query) I want to take the value OfficeNumber (on the form it is me.OfficeNumber which I have stored in the var aRoom) I need to look up the jack that was selected in the listbox of this form, that I have stored in the var aBox I need...

I am working with 2 tables (one the control source of the form, the other queried) Before you ask, no I cannot put them together on a query as they share a common field (the room number). The form show the information for the currently selected room. I have made a list box that lists all...

I am trying to work out a process in which a value from the control source in a form gets put into another table. I can go into the details if needed, but for now, here is my problem. here is the bit of code (I have commented out all but the OpenRecordset stuff): Private Sub...