Convert VBScript to VBA - so code can be used in an access project.
Yesterday I had a problem whereby I need some vbscript code - to search text files in a given folder and sub foler for a te...
When coding in VBA (Specifically MS Access 2007) how can I get a list of a folder's security permissions, specifically what users/groups have access to them?
I am generating SQL code in Private Sub CloseForm_Click() and passing it as an argument, strSQL, to the form, "2007 Job Log" which I open inside CloseForm_Click() with the following command:
...
I'm looking to write a function to call via a query which will clean up some unwanted characters in some data I was given. I can successfully strip out the first occurrence of the first chara...
Hi everybody,
How do I delete a record from the recordset, I wanted to check if my record on my table exist on the other table? I am using ADO and MS access VBA. The problem is I wanted to ...
I have a form that my consultants use for contact management. On the form I have a sub form that is used to log each contact with the client. I have added a new command button called "Left Me...
I have the following script giving me an error 6 - buffer overflow:
It occurs when the folder size is extreme (in this case example - the folder was 45 GB)
Anyway I can prevent this from hap...
I have a MS Access database that has several queries in it that run one report. It's date driven (therefore I enter date parameters FromDate - ToDate) and this is in all 11 queries that I have...
I have a button on a form that will delete the current parent record via Me.RecordSet.Delete. This parent form has 5 subforms. Each subform is displaying a record associated with the parent ...
I have attached a file (Excel). This is a sample file of an regular download from SAP. I run that Job on a daily base and save the results as an .xls file, but the Data is almost like "throw...
I need to change the field names in a number of MS Access tables to standard field names than I have defined.
I have attached the code I was trying to use.
The line: Set tdef = Current...
Working on databases (multiple) that are linked via ODBC.
Getting the error message listed when trying to open link.
Can set up the link and open it fine while in Access, but once user gets ...
I'd like a control button on my form to close all open forms.
It is possible?
How to combine 2 similar access tables into one new table
Hello, I am trying to create a named range in a dynamically created excel document that is created from some VBA that is kicked off through an MS Access 2003 db. Here is the code I am using. ...
I have submitted some code below. How would I use a query in a recordset instead of a table? Is this possible? i.e. instead of Set rst1 = dbs.OpenRecordset("table1") I might have: Set rst1 = d...
We have the following bit of code originally created in Access 2000 (Windows XP). Now that we are upgrading to Access 2007 the code is no longer supported.
Set fs = CreateObject("Scripting...
I'm sure I did a terrible job describing my question and hopefully I can do a better job here.
I have a query (final query) that is the result of several other queries. There is a unique fi...
Hello All: This should be simple but is elusive for me. Ultimately I need the record count from a sql statement, so I don't the actual recordset; merely a count or records that satify teh qry ...
I prefer continuous form view over Datasheet view - but I miss being able to delete a record like I could in datasheet view.
What I would like, is a continuous form view that basically has ...
Hello all,
I'm pretty familiar with coding in VB and VBA but this one I don't seem to solve for myself. At the moment, I'm making a small Access Application that helps me control my network...
Hello,
I have 3 boxes/fields in a search form. I can perform a search by filling out 1 field, 2 fields or all 3 of them.
The fields are
1 combo box (I can select a country, say Canada...
Inserting a picture into excel from an access database
Hi,
I have an application which needs to output some text to excel but also include a company logo dpeending on which company the fil...
is there a way in VBA to make a query datasheet scroll to the bottom when it loads? The only thing I'm finding with jumping to the last record is that it is hidden behing the record selector ...
i have this code
sqladvanced = sqladvanced & " where live.[SalesPerson] = '" & cborepsearch.Value & "' and live.[" & cbocriteria1 & "] = '" & txtcriteria1.Value ...
