Search results

Good Morning All Before you ask, yes I have searched through the forum for this particular query but allow me to shed some light.I have a number of devices (printers, monitors, ID Scanners etc) that may or may not be associated with a particular PC If associated with a PC may or may not be...

Thanks vba The save command was commented due to debugging in design mode. The close button on the form is disabled hence a close command button (too much drama in the past with unloading a form before closure - this makes life easier). Me.txtnote is unbound. I threw it on the form mainly for...

Thank for your input. In fact this is the exact idea i was considering following a suggestion from spent but I think the boolean variable should also suffice. I think i spent too much time trying to see if the command button had a property of some sort that would actually store click events...

Spentgeezer I havent actually seen your code yet but i think i have an idea of where you might be going with the invisible label - that is definitely an optionn Hey VBA I am enclosing my curent save code. What are your thoughts. Let me know if you need any clarification. Just an fyi, my save...

Hi all I have a simple form with 3 text boxes and 2 command buttons. The buttons are for saving records entered on the form and other is to close the form on the basis of a warning message box ie if confirm you wish to close = vbyes then close the window else cancel = true 'leave window...

Thank you for your very insightful work Galaxiom. The scary thing is jumping in on the risk (just like opening a business). I accept that there is so much more to do and learn. Honestly I have not got into integratiing Access with Windows yet but this will be something I will be looking into as...

Bizarre heading for a topic i know but i was wondering if i could get your general ideas and thoughts. Yes I know access vba is a huge programming tool and one learns daily (trust me i know this only too well). Yes i also know requirements vary from company to company and from programmer to...

You guys have really helped me out a lot while building this app. Thanks JANR, that worked perfectly. Just what I needed. It returns null if rst.EOF is true otherwise it gives me what I need.

Hi All I am sorry to keep coming back to this post but my debugging is going really well ;). I asked last week about a situation where my recordset column returns a null value and namliam mentioned the Nz function which was perfect for me last week. The issue I have now is that if the recordset...

I did and it definitely checked out Nice one again

Hi NamLiam or Bob or anybody Just going off the above. If as an example strModel = rst!model rst!model was null in the table, it errors out as there is no data naturally. Is there a way to tell access that for example if rst!model = "" OR isnull then the associated string...

Yeah already did that Namliam but thanks for clarifying By the way...Thanks Bob for your insight into opening the Recordset. Something new I have learnt as well. Thank you

namliam You are da man/woman lol Got my variable pulling the model now...ill try it with the other 3. I'll store these variables globally to make them available to other forms.

Ok Bob Sorry there was a typeo When I run my code, I am getting a runtime error 3061 Too few parameters. Expected 1. I am trying to store the model, manufacturer and serial (all of which exist on a table) of a device based on the user's selection. If the selection is a printer, the query...

Hey Bob The line Access is unable to find properties for currentdb - are we missing something here.

Hi All Hopefully this is not too difficult. I have a declared string dim strModel as string I am trying to run a simple SELECT statement "SELECT column_name FROM table WHERE combobox = column_name" I am trying to store the results of that query in my string but, get this, when i...

Kryst, Bob You guys are life savers. This works like a charm...Thank you for your help..VBA continues to puzzle me. 3 criteria coded the same but generates a mismatch. At least now I know to declare only one string as supposed to 3.

Thanks Kryst. Ill test this out on Monday and give you feedback.

Hey JDraw Tried that scenario too and that also generates a type mismatch

Hi All I have spent the last 2 hours trying to troubleshoot this problem. Please help. I have a form with 3 combo boxes where a user selects information they want loaded on a second form. Form A has site, builidng and facility represented by these combo boxes. When the user clicks load...