Search results

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...

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...

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...

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.

Hi, I have a continous sub form which contains two fields. Field 1 - AllowUpdate , which is a Yes/No field already set in the table which the user can not update. Field 2 - Current Sales, which i want the user to be allowed to update if Field 1 is set to yes. but if its set to No then i want...

Hi, I have a two column data range in a worksheet that id like to use as a data source in Excel Forms, how do i reference the range in the form control.

I have to normalised data lists, i want to effectively de-normalise (if thats a word). I've attached an example which will hopefully clarify. But i have a table of products and want to list attachments which match each product id, in one cell.

Anyone now how to copy a range that contains some duplicate records and only paste original records. I have a range of names, some repeated and i want to creat a copy in another sheet only showing each name once. I want to use VBA without a pivot table?

I have two spreadsheets, i want to perform a lookup to populate a column in spreadsheet A, from data in spreadsheet B in VBA. However the data in spreadsheet B may contain mulitple matches for the lookup field, in which case i just want to return a string "Multiple Records". I could probably...

I have a continous sub form which i need to run validation against when a button is clicked on the main form. I suppose the best way is to loop through each record in the sub form. - How do i determine how many records there are in the sub form using vba? - How do i reference a field in each...

How can i set the workgroup security to allow users to view and add records through a form without letting them open or view records directly through a table.

I have a continous form in which the user enters a batch of records each row has a unique field relating to a document. The db records this and the users ID and date of entry. ++++++++++++++++++++++++++++++++++++ Batch:1010 ________________________________________ DOCID : USERID : TIMESTAMP 101...

I have a DB with 7 users on a network, I'm thinking of switch the Front ends to compact on close. A) Will this compact the BE. B) Will this cause problems if one user closes and thus compacts the BE will the other users are still connected and using the DB

Is it possible to administer work group security via a form. eg Add/Delete Users Reset Passwords Lock User access Also is their away to pull the current users login and group membership details?

I'm trying to abbreviate the code below. MovementType(1) = Me.Type1 MovementType(2) = Me.Type2 MovementType(3) = Me.Type3 MovementType(4) = Me.Type4 into somthing like this, but i can't get it to work?? For I = 1 To 4 MovementType(I) = Me.TypeI Next I How should i reference the...