Search results

If you're doing what it is I think you are trying to do ie lock down form2 clicking a button on form1 then the Oncurrent event is not what you need as this will lock down the form as long as it has focus and also for every record that it is bound to. From form1's button click event, instead...

Thanks Gemma and Spike. Aside from venturing into the newly discovered DOM world i think I am going to find a way to keep everything running from inside Access instead. Venturing out into the world of XML and ASP is at this stage beyond me. Thanks for all your help.

And I thought I was almost there with access. So in your opinion this would be the only way to interact with a website from withing VBA

Hi All I am not sure if I am pushing my luck here but I have a database that holds PC info along with several other devices. In my PC table, I have a number of fields holding service tags and Manufacturer info for different brands eg dell and HP. I am trying to create a form where a user...

Lol...I've been scratching mine for 2 hours.. Thanks for your help men..I'll know the route to take when this occurs.

Galaxiom That worked like a charm. My question now is shouldn't the LEFT JOIN clause take care of returning null values if it cannot find a matching monitor?

Very simple SELECT PCS.Device_Name, PCS.Model, PCS.Manufacturer, PCS.Serial, PCS.Reg_User, D.Device_Model, D.Device_Serial, D.Device_Type FROM PCS LEFT JOIN devices AS D ON PCS.Device_Name = D.PC_Name WHERE (((PCS.Device_Name) Like 'ARTI%' Or (PCS.Device_Name) Like 'HOHE%' Or...

Stopher The word grid is what i was looking for and that could probably have made life easier for everyone. This is the exact concept my destination form has. I am out of work now but will love to test this along with Brighton's look. One question. actually 2 1. Are you saying as long as my...

Ok I can sort of see where this is going. I'll work on this first thing Monday morning. Thanks for all your help today men

Wow Chris This is the point at which I say no speako Englis... Ok I get once the function is created.. The question is writing such a function that uses a textbox name as parameter. I am almost clueless as to how this would be written.

Chris i appreciate you even looking into this for me.. At least I dont feel like I am being chewed out about my design. This definitely goes where I am thinking. My initial question was asking however if there was a way txtbox1,2,3...7 could be put into an array and allow for less lines of...

This would have been fine Chris but the new form these serials are going has 7 textboxes (along with other controls). The idea is that each extracted serial should fit into each textboxes. Serial 1 = textbox1 serial2 = textbox2 and so on All well and dandy except if serial 1 is null then it...

Hey Chris In fact that is the exact route my design took. I have several subforms that open in tabbed pages where if a user clicks on a PC, corresponding data about that PC ie what individual device is connected to it is displayed on each tab ie Monitor, Printer and so on. As mentioned, the...

Nice thought and the mere reason we all spend years trying to normalize every crunch of our tables...just a thought..I attest to the fact that although necessary, real life acceptance must also come into play...like software testing, no database is truly ever 100% normalized is it?

Thanks Brighton OK so some history lessons while we are at it. I joined this department while they were still working with scrap notes and xls files trying to account for 600+ PCs and a whole bunch of devices connected to each PC eg Printers, Monitors, Scanners, Cash Draws etc etc. The...

Thank you all..I'm trying to push away from the issues of data normalization and denormalization for a sec and just ask that given the above scenario is it possible to check a group of textboxes in an array for null values

Hey The form is normalized as well as the data behind the form (which is reading of a view from 7 tables) The users can input as many as 7 different devices onto this form which in turn generates a paper based version of their entries. The idea is for a user to search for a specific device...

Hey Is it possible to check for the following My form has 7 sets of textboxes on 7 different lines so line 1 has id1, device1, serial1, model1...up to 7th box line 2 has id2, device2, serial2, model2...up to 7th box I have some values to input into these box sets automatically but I need a way...

So James I got to thinking and I was able to resolve using nested iif statements to return different values based on differing scenarios. It was a hell of a SQL Statement but it worked. Thanks For the rest of us SELECT iif(table1.column1 is null, "Output 1", iif(table1.column2 is null...

Thank you James Yes I could use the iif function, the question is how? I tried using that at SELECT DISTINCT PCs.Device_Name, Monitors.HR_Number, NZ(RPrinters.HR_Number,"Not Found") AS [Rectrac Printer HR], CDisplay.HR_Number, CashDraws.HR_Number, CPS.HR_Number, IDScans.HR_Number FROM...