Search results

I am having a really annoying problem at the moment. I have VBA code that makes use of the Microsoft Office 14.0 Object Library, but if I have this selected whenever I try to do anything in the Form Design view it is constantly freezing. It will literally say not responding" for a minute or so...

I have a checkbox on my form that basically deletes a record when the user ticks the checkbox. What I want to know is how do i check whether the person is "ticking" or "unticking" a checkbox before any action is carried out?

I've been wreaking my brain trying to figure this out and I have a feeling i am looking at it the wrong way. Basically I have a continuous form with each record having a textbox and a checkbox. There can only be one checkbox ticked per record but what I want to do is to stop the other...

I would like to compare the values of several columns in the same record and remove any duplicates. So... ID | Col1 | Col2 | Col3 | Col4 | Col5 ------------------------------------------- 1 | A | B | C | D | C 2 | C | C | C | D | D 3 | A...

Hi everyone, Sorry if this is a bit of a simple question but I just want to understand exactly how the "Instr" function works. So in my scenario I want to extra the first letter of someone's surname and I actually manage to get it to work using the code below. initial2...

I am having a very peculiar problem with my form. I basically want to open a form as a pop up window but when I selected this option in properties the form opens up really small. Does anyone know what might be causing this? Thanks.

Hi everyone, I am having a of trouble doing something which you would probably find really simple but I am pulling my hair out and I am not really having much luck finding and solutions either. Here is my problem, bear with me... So I basically have a form which the record source is either...

Hi, I am trying to do something which should be quite simple but I can't get it to work. Basically I just written a code that scrolls through a dataset and when it finds a null field it will change it to "-1" but my code isn't working. Any help would be appreciated. Function FldTest() Dim...

I don't have much experience with creating pivot charts so please bear with me. I basically have a table like this: | EmployeeID | Day | HoursWorked | | 1 | 1/11/12 | 5 | | 1 | 2/11/12 | 6 | |...

Hi, I am looking for a way to allow a user to press a button and open up a browse window to select a file. Once selected, the file path will be put in a text box. I've already had a look on the net and found various solutions but I can't get any of them to work, including one very popular...

Hi, I am just wondering whether its possible to have an sql query that will refer to the content of an object on the form? Basically something like this: SELECT me!cboSearch.Text FROM tblData WHERE tblData.&me!cboSearch.Text = 5; Thanks.

Hi, Does anyone know how I go about extracting numbers from a string? At the moment I use a loop to go through a string and then use the IsNumeric function to extract any numbers in that string and put it in another variable. However, this only works if it was a single digit. However, what...

Hi, I have currently set my recordset to the following: Set rs = db.OpenRecordset("SELECT RecordNo, CarModel FROM tblCarData WHERE CarModel Like 'Ford*'", dbOpenDynaset) So that when I insert data into a new table I can output the RecordNo and CarModel but I only want to look through the...

I have a very simple question. Basically I have written a piece of code that loops through a field and identifies the numbers and depending on what the number is it sets it to one of the option1, option2 etc variables. But when I run the code, I can't get the option variables to reset when it...