I copied a database from a colleague and got the above 3027 message. I edited its properties and unchecked (I can't quite remember) a box about "from another machine" - and unblocked it. It is NOT read-only
I cannot overcome this and now an older copy that I created is also giving the same...
I have simplified my problem to the basics - 2 queries from a simple table - here is the table:-
Input
ID ctry
1821 China
1822
1823 China
query 1: (IM)
SELECT Input.ID, Input.Ctry, 6 AS Pts
FROM [Input]
WHERE (((Input.[Ctry]) Is Not Null));
result:
ID Ctry Pts
1821 China 6
1823 China 6
query...
I have converted a 2003 mdb to a 2013 accdb and now my modules won't compile. I get (for findfirst) - "method or data member not found". Do I need new reference libraries or something?
code below:-
mySQL = "SELECT * FROM [5-4AveSchoolBySector] ORDER BY [SID], [Sect];"
Set myPercs =...
I have a table with an autonumber/counter which has all records deleted (through code) and I wish it to reload the table starting at 1 (again through code). If I copy and paste the table (structure only) in the database window this has the desired effect but I can't find a way of coding this. I...
Access 2003. I have a form which constantly loops calling another form (Import_Export) every n minutes (parameterised - set to 5 minutes at the moment) to process files which the user has dumped in a folder. It runs happily for days and then eventually crashes on the form open with the message...
I've had to re-install smartsuite release 4 ( I only actually use 1-2-3 release 5.0) and now, although it opens wk3 files and some wk4 files without problem, it hangs when I try and open most of my wk4 files - any help appreciated
I have a program that loops forever picking up files and processing them every 5 minutes (in an outer loop) but after some time (not fixed but usually about 6 days) it stops picking up the files - I have found the problem to be that the filesearch.execute is eventually returning 0 even though...
I've seen various posts re this subject but can't find a solution out there that doesn't involve either amending the registry (and I can't do that at my client's site) or manual intervention (and we don't want that). I am importing an excel file via transerSpreadsheet in code behind a form, and...
I am importing an excel sheet with the transferspreadsheet command and I need to be able to reference the original Excel row number - is there any way I can add an autonumber key as I can when File-importing (specify "let access add primary key" and it gives an autonumber ID) ? Without the ID it...
I am writing code behind a form to read emails from a specified outlook folder, download attachments and do various other processing. I am unable to find the code to get the sender's email address. I can get the recipient (the TO name) with .to (although it requres permission to be granted). The...
I asked this question back in March and got no replies - I'm still wanting to do this - so am trying again...
I need to read an attachment to an email in Access - VBA on a form. I can get at my inbox with File-Import/Attach but this only tells me IF there is an attachment or not - I actually...
I can link to/import my outlook folder contents but I need to read the attachment and this command only tells me if there is one there or not - surely there is a way to actually open and read the attachment??
Any help gratefully received
I can link to/import my outlook folder contents but I need to read the attachment and this command only tells me if there is one there or not - surely there is a way to actually open and read the attachment??
Any help gratefully received
I have some old code that has worked for years (up til 2000) but now gives me "invalid procedure call or argument" in 2003
Dim dbs As Database, rst As Recordset
I have tried DAO.Database/Recordset and still get the error
I have the same references as before including
Microsoft DAO 3.6 Object...
does anyone know if you can write code (in VB or anything else!) that can automate the dowbnload of an attachment - when a certain e-mail comes in the user would like to press a "button" and automatically have the attachment downloaded to a specified folder.
I am using the following code to delete a file and then copy another to it - my problem is that the scripting causes McAfee virus checker to prompt the user to continue - is there an alternative way to do such operating system related tasks without causing McAfee concern please?
Set fs =...
I would like to code a procedure that (given a known folder name):-
loops around a routine which
imports file beginning with "xyz" (of indeterminate types)
appends file to a combined table
moves said file to sub-folder (named archive)
the import (once I know the file name) and append I don't...
I want to declare an array of variable names and contents and then code a loop which sets them
e.g. set var1 to "a", var2 to "x" using an array like
dim a(2,2) as string
a(1,1)="var1"
a(1,2)="a"
a(2,1)="var2"
a(2,2)="x"
'and then
for i=1 to 2
&a(i,1)=a(i,2)
loop
but...&a isn't right -...
I want to open a form sometimes as read only - I have tried both me.allowedits=false, openform.........acReadOnly
BUT
it only sets this after going to a subform and back - I can change the data on first entry, but as soon as I switch (the form loses the focus?) and come back then I cant change...
Does anyone out there use OLE to interface with Maximizer?
I have a very simple piece of VB code that hangs off a maximzer toolbar button. It returns me the current company information no problem. I then want to loop through all contacts for that company and I can't find the commands to access...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.