Search results

You can have a form on a timer, if you just want to splash a message up which then closes

Sorry is this an excel question or are you after general advice on setting or measuring a KPI.

i would suggest you just tidy the data before importing into Access. You can use formulas to build the broken description back up into one cell, eg =F1&F2&F3 then filter out the duplicate records. Or if its going to be a repeated task, just create a template you can past the output into that...

I don't think it will be possible to do this on the fly, eg replace a mr with Mr as its typed by the user, certainly not using validation. Choices would be. 1 - Add mr to validation then either live with have both mr and Mr or loop through after entry and replace mr with Mr or triger an on...

I Presume the form being used for entry is not bound to either table. If you need to do unbound then: I would suggest you create a temp table and use an append query to add to the detail table if the record does not already exist, then run an update query to update the visits table with the...

Hi, I have an application that requires a port number to be open to function. How do i test in VBA if a user has opened the the required port number before i run the main piece of code in my application. eg Is port number 1234 open? If true then, else exit. Thanks Clive

I'm running a stored procedure on a remote sql server to populate an ADO recordset in access VBA, how do copy that recordset to a table without looping through the recordset. In excel i could just use copyfromrecordset to paste into a worksheet, but i can't work out how to do something this...

Hi, Hope someone has tried this before. I want to set up a serious of forms to ask the user questions and record answers using buttons in forms. I have a table of questions, each question will be read from the table and the answer recorded next to it. My issue is that i will be using several...

Hi Guys, Hope someone can help with the below. I have a split database, with the backend saved on a network. 1) How can i retrieve the name and location of the backend in VBA? 2) Is it possible to change the linked location for each table via VBA, say for example if i wanted to switch the...

Thanks, I'll try both suggestions and see which works best for me.

I'm trying to set a variable in a form and store the value for use in other forms even after the initial form is closed. I don't wont to write to a table and i think this can be achieved using a static declaration in a class module, but am unsure how to do this? Any help greatfully recieved.

Hi, Hope someone can assist with this problem, which i need to solve without using VBA. I have the below table of events, From - to dates and event description. From To Event 07/01/2012 09/01/2012 Contract1 11/01/2012 14/01/2012 Contract2 I also have a straight...

Are you sure you want .caption can give the value of the ncount variable and Me.userlookup.Caption

thanks for this guys, sorry for delay in response, been away.

I am trying to use a SumProduct Formula with one criteria being an array and it is working in part, but when i try and expand the criteria array it only works on the basic formula not the more complicated one. Data is Structured as below Column B Numbers from 1 to 10 repeated many times Column...

Thanks Guys, Guess i will have to pass through a function. I attach your file back with the problem highlighted in an additional form ansentry, just to clarify the issue. (don't have winzip so ive just renamed .zip, but if you rename back to .mdb it should work.

yeah even i thought of that, lol. also tried setting table field to long integer which cant even store a decimal still wouldn't change, on verge of routing through a query and running each column through a Format() function, just to see if that will do the trick, but their must be something...

yeah, i suppose that would be helpful. I can get 222,235,244.00 or 2222352444 but what i want is 222,235,244 thanks

Not having a good day with number formating. How can i display (,) seperators in a text box which update as a user enters a value, having users enter high values and im concerned about typo's.

Think i must be missing something but im having real probelms formatting numbers show in a listbox. I want , seperatots but not decimals, dont seem to be able to one without the other. someone put me outta my misery please.