I know this is a regular topic in here.
there is a way to disable the shift key and prevent users from opening the database in design view. But is it possible to assign the bypass to another key other than shift?
im hoping someone can help me,
Im new to VB and cant seem to get this code to work,
the code is available elsewhere on this site but im trying to get the code to only look in a specific folder
the folder "scottish southern" is in my inbox in outlook...
Someone please help
Im new to VB and cant seem to get this code to work,
---------------------------------------------------
Function Item_Open()
dim objNameSpace
dim objFolder
dim objItem
dim objAttachment
dim intIndex
dim intIndex2
dim strFiles
dim DefaultFolder
set DefaultFolder =...
Ive obtained this code from another thread,
option explicit
Function Item_Open()
dim objNameSpace
dim objFolder
dim objItem
dim objAttachment
dim intIndex
dim intIndex2
dim strFiles
set objNameSpace = Application.GetNameSpace("MAPI")
set...
Im using this bit of code to move attachments from outlook to a specified folder.
------------------------------------------------------
------------------------------------------------------
option explicit
Function Item_Open()
dim objNameSpace
dim objFolder
dim objItem
dim objAttachment
dim...
I have a module that i use to import a number of files from a set location.
Is there a way to tag the filename onto each record as it is imported so i know where the record came from.
this is the code im using
-------------------------------------------------------
Function importXLS_files()
Dim...
Ive got a main splash form on my database, the form contains a .bmp image. in the properties of the form the picture property shows a path to a linked image but the file does not exist, and if the link is deleted the picture dissapears from the form, the picture type property is 'embedded' but i...
I have installed VPC 6 on os 9 on my ibook, everything worked fine, windows installed great and i even installed office and used the ibook for number of weeks without any gliches, until i installed osx, then it kept crashing, so I cleaned the drive did a full install of 9 and x and installed...
Does anyone have an example database that has a form which can browse a users directory listing all folders and/or files. then return the full path of a selected folder and/or file to a text box on the form.
ive been trying all week to build one using the codes ive found here but had no luck...
ok, this is what im doing:-
I have a table of customer registrations, the registrations can come from a number of sources and are loaded into the database through an input form by a number of bods.
what i want:-
is to have the primary key checked once its loaded and a message box to appear if...
I need help fast.
i have hundreds of files which i need to import into access, they are all text files but access does not recognise the carriage return within the file so i get one record from each file, e.g:-
"Field 1",Field 2,"Field 3"->blacksquare<-"Field...
this is probably very simple,,, how do I set the criteria in a query to only return records where a certain piece of text is contained in the field.
i.e Like "*Front Street*" Never ever, bloody anything, ever
Hi
I need a macro that is part of a bigger macro to look for a value. i.e. the username. so:-
If username="me" then openform1 else openform2
but i cant get it to do this. the actual function of the macro is to open a word document which is located on a shared drive, but i want to...
Does anyone one know of a way to insert a record into a table and then assign it a delivery route number, im building a database for a friend which will manage his milk deleivery route, i need to insert a customer in the delivery route and then reassign a delivery route number to all the...
I am getting the following error message :-
'' isnt an index in this table. Look in the indexes collection of the TableDef object to detarmine the valid index names.
the database is then not opening, and i cant import into a new database shell either. please someone tell me what i need to do...
I have a form which holds data, data on the form can change at any time and i want a refresh action to happen at regular intervals, but because i have linked another form to open on the on timer event i cant have the form close and open in one sweep. so i need something that will just refresh...
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.