Search results

Brilliant Vba. I think when they run the LIKE search..ill implement it where on double click of their chosen machine, the other subforms (tabs) will auto populate. Cool

OK Took the idea to my super an he likes it..We will go with the tabbed view each showing a separate device linked to a combo box on the main page where the user selects a PC name. I am having to run very simple code as he would want to search for a name of a device with the LIKE function...

Thanks for all your help VBA. I guess the final thought of the day is that I am never going to be able to have a row/record where ALL related information pertaining to the PC is present. So in my main form, I will have the user select a PC and then run code (PL/SQL) that populates each sub...

"It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables." My joins are all left joins and I am unable to remove some of the tables if i need the query to retrieve the information i need from specific tables. I am attaching my query as it comes from...

Thank VBA i had actually come across that post yesterday...What I am hoping to get help with if at all possible is a suggestion on designing this query where I CAN make edits to the tables on the fly because I dont know where else to go. Might have to end up throwing all 30 -40 fields into one...

OK Thanks Bob and Trevor for your suggestions. I probably need to upload a sample of what my form looks like right now so you guys can understand my dilemma.. At my office we are trying to track all our IT assets - PCs, local printers, cash draws, scanners etc. I have the PC as the parent...

Not sure what you mean by "complex" here Trevor. I guess my question is, is there anyway to get around this?

Good Afternoon all I have 2 forms that are both based (bound) by a query (Query A). My query has 9 tables in tables each joined to one central table by left Joins. When the query is run, i need to be able to make changes to or update the records on the fly. To my strange surprise, I am now...

Hey Crake A very good idea. The only thing is I have my dashboard mounted up on a 22" Monitor in our office. I needed to have both the ticketing info as well as any updates from our dashboard that pulls info from another table. So not sure if this will be large enough to display.

You have been a great help. I have one final question. On that same form I am using as my dashboard, I have a timer event that is running that runs queries on textboxes every second. This includes date and time textboxes that act as a running clock (ie timer() requerying every second). When I...

Namliam Thanks for this. This works like a charm. Question; This scrolling text will be on an updatee dashboard so I need the loop to be somewhat infinite. I guess is my question to keep the loop going. Any thoughts. I really appreciate your help. I have been able to adjust the speed of...

Can someone please look at this code for me. I got this code of another forum (forgot the user's name so unable to reference) but all I am trying to do is get text to scroll from left to right in smooth transition. The below code works Private Sub cmdscroll_Click() Dim x As Integer, y As...

Hey John (fyi...your last name has been the joke of my office). Made some slight mods to your statement and its all working ok. Yes an unchecked box is supposed to load all information on the report Thanks a million for your help.

Hi All I have a form that i have incorporated 3 checkboxes that represent 3 sites ie checkbox A = site A, checkbox B = site B etc. My form also has a sub form (datasheet view) that loads information on all sites by default. What I am wanting to do if for a user to select a checkbox and for...

Thanks for the detailed response. Have been real busy and havent had a chance to test this yet. Will get round to that today and let you know how I got on..

Thanks for coming back Yarp but unfortunately thats not what I was looking for. The main issue I am having is that when I declare a variable as a control and ask access to check the control type. I am not finding an option to unlock the control if the type of control is a textbox. (its not in...

No the textboxes are not grayed out. They are locked meaning text can be copied from them but not edited. I actually need the locked = false event (an event which is true for textboxes) but not available in this case Thanks

Hi All This is simple but driving me absolutely mental. I have a form that loads with certain textboxes locked by default. I am trying to unlock these textboxes if newrecord = true and have the following code Well turns out, ctr.locked (the even i am looking for) is not an option and the...

Hi Gemma I am not sure what your post is trying to say. My form is loading "dirty" as this is how I do want it to load. With pre-filled textboxes that are bound to fields in the underlying table, eg current date. Bob Thanks for your help as always. Just trying to understand what you're...

Hi All I have a situation that has been driving me absolutely mental that I hope someone can help me with. This is a simple procedure. I have a form that loads pre-filled with some information on it like a textbox with the current date and 3 other text boxes that load disabled and have contact...