Search results

Hello, I have been trying to find a way of searching through some records in Excel (test data in Data worksheet), and then displaying the results of the search in a list box. Whilst searching various sources on the internet I came across a partial solution which is shown on attached workbook...

Hello, I am trying to find out if there is a way for me to create a table based on a specific month. For example I might select January 2005, I would then want to create a table with all the days of that month included, so that I could then add specific data to each day. Is there a way that I...

Hello, I am trying to copy folders within code and thought I had the answer in the following code which I found on this forum. Dim fs As Variant Set fs = CreateObject("Scripting.FileSystemObject") fs.copyfolder "C:\Documents and Settings\szymkm\My Documents\test", "C:\Documents and...

Hello I have been searching through this forum to find a way of exporting a report to a PDF file. I have found the answer and tried to get it to work but keep getting an error 2202 (you must install a printer before you print etc.). I was wondering if anybody knew what I was doing wrong as I...

Hello, I am creating quite a complicated report and need to pull some information from a query for calculation purposes. I could use the Dlookup function but this would make the report slow and since the report is run and exported 400 times for seperate customers this would compound the...

Hello to anyone who can help, I am trying to update a table from VBA using another recordsets output as the criteria to select which field will be updated. The output is also used as the criteria to select what data is used to update this field. My objective is to update 12 columns in a table...

Hello all, I am trying to find a way of creating a query in code and to pass the result of this query to the variable 'Per_Num'. I wondered if this could be done using a recordset? I have looked through other topics but am unsure how to use the recordset. Any help would be much appreciated, I...

Hello to anybody who can help, I am trying to update a table by using the code below, i know that it works without the criteria but as soon as i use the 'Where' things go wrong. I currently get a type mismatch failure, if i change the = to like it runs without error but does not update the...

I have a list box and I want to set the record source within VBA using SQL. I have a query and its SQL code, what I would like to know is if the SQL code I have got can be used as I would like or if it cannot, what can I do to change this? Thanks to anyone who can help. The code is as follows...

Hello, I have a form with a command button on it which requeries a load of controls on my form. I also have a popup form which I open from the main form, this popup form contains a list box. My problem is that I would like to call the command46_click (main form) procedure when I click on the...

Hi, I have a pop up form which contains a list box. When I click on the list box it populates a text box on the main form and sets other boxes to "". My problem is that i cannot get the controls on the list box to requery the text box each time I select a different record from the list...

Here is my problem:- I need a function to check for unwanted characters in a field (for example ("," " ",""") and then replace them with a single space. I think I have found a piece of code from an old employee which was designed for this purpose, but being a total beginner I do not understand...

Can anybody help? I am trying to preview a report but when I click on the button it comes up with Runtime Error 7794, the tool bar "CSprint" is not available. I have other reports that preview fine and cannot find any information about what could be causing this. Thanks to anybody that helps.

Hi, I have a piece of code that is supposed to check a table for the last date in it and if it is not yesterdays (or fridays date if opening on a monday) then it is supposed to import a text file. The problem is it is not recognising the last date and so just keeps importing each time. Here is...