I have been reading a lot about Access Runtime and the problems that occur when a runtime application is installed on a machine that already has a full version of Access. Any program that can be used to create an .EXE type file for an access application that will eliminate all of these problems? The cost of the compiler program is not a major concern if it works!!!
View RepliesI have a series of 7 separate Access 2010 programs that are designed to run under the control of a scheduler, and they must always finish. Errors are trapped and logged but mustn't stop the processes completing.
What I'm trying to do now is to create a single master control program that runs each individual application, one after the other, in order. And each individual app cannot start until the previous one is finished.how to call a separate Access program and know when it has finished.
how to create web application using ms access. my requirement is i have an inhouse developed retail invoice application ( ms access 2003) which i need to move to web based.
View 2 Replies View RelatedI was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.
View 2 Replies View RelatedOkay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..
View 1 Replies View RelatedTrying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.
When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?
How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.
The use of file is only in desktop.
Hello,
I once used a program, when you click this .mdb file, it opens a main Form interface that user can run programs such as view report etc. That is, all tables, querys reports, other forms are behind the sence (user does not need to know them).
Could anyone tell me how to do this? Thank you for yoru help.
I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.
Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.
I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?
I wanted to create a field lookup with values that I specify, not on the table sheet, but on the form. User can click on a text box or combo box and can select a list of value that I specify, not values that are listed on a table but ones that I type in, in the form.
View 11 Replies View RelatedI have to create a flat file to send to a group each month. The file type I create is M(a 7 digit number).(a three digit number), like M1234567.123. I create it as a text file and rename it from a field on a form. The field is in the last line of code below, WaiverFile.
START OF CODE
Dim NewFormName As String
DoCmd.TransferText acExportFixed, "WaiverFiles", "qryViewWaiverBilling",
"C:PSWaiverFilesPSWaiverFile.txt", False, ""
Dim stFileLoc As String stFileLoc = "C:PSWaiverFiles"
FileCopy stFileLoc & "PSWaiverFile.txt", stFileLoc & Forms!frmDailyLogOptions!WaiverFile
END OF CODE
I have a procedure that this is part of. The next thing I need after the code above is to copy this file, M1234567.123, or “M?.?”, to a folder on a mapped drive, that is T:PSWaiverFiles. I need to copy it as M*, so that I can get the file every time. I have tried several things, including:
START OF CODE
FileCopy “C:PSWaiverFilesM*”, “T:PSWaiverFiles”
END OF CODE
I have 4 queries in which data needs to be connected from the date and shown as a single date showing each sections entry in a row and a cumulative total is maintained as the balance .
See the attached image ...
hello,
I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).
I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?
Tokunbo
how to create file explorer like functionality in ms access.
1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories.
2- I also need to be able upload (copy/paste) folders and files in that directory
I looked at different solutions and found a solution which might work on this foum link below.
---access-programmers.co.uk/forums/showthread.php?t=102667----
The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.
Looking for a way to use transfertext to make a table and create a spec file from csv files I am importing. I want all fields in the table to be shorttext.
Otherwise I need another way to bring the files into a table.
I have a generic spec to use that brings in any data as text.
Created the spec from a delimited file with 255 text fields... Field001, Field002, etc.
However the field names need to be changed. My field names are in the first row of a table. I will need to read each fields data in the first row and rename the field.
I have limited programming skills but a basic understanding of databases.I want to create a database in Access that links to contacts in an Outlook pst file, and in the Access database I want to create a series of date dependant tasks or processes that I can apply to the relevant contact.The object being to to save that collection of tasks to apply to different contacts within Access.
View 2 Replies View RelatedI'm currently working on a project within access which will allow users to select/input information in a form which will then save to the database.
What I need is to create a button on the form which will allow you to convert the data collected from the form to a custom text file template.
(Or maybe the last row added to the database. - although this may cause errors. Example: the form information doesn't save which will in turn create a text file with the data collected from the previous job)
The custom text file template should have a sentence description followed by the value recorded from the form.
Example:
1 configuration type: (data from form)
2 model type: (data from form)
3 Poc: (data from form)
And so on.
So in summary - I would be to use the form to collect the desired information which will save to the database.
Once actioned, a custom text file should be populated with the collected information (with specific data placement as per the example above)....
Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?
I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.
I'm using Office 2010.
I have a database that I plan to use to help us manage an old "Remedy" system....
There is a field for "Ticket number"
I want to be able to click a button and have this ticket open in Remedy.
Remedy DOES have a link system. When I creat a link it creates a file like this:
Ticketnumber.ARTask
The contents of the file are simple:
[Shortcut]
Name = NTRS-Trouble
Type = 0
Server = samson
Join = 0
Ticket = NTRS422904
The name of the file seems to be irrelevent.
How can I programatically get the button to re-write the ticketnumber into that file, in that spot (after the letters "NTRS") and then have it open the link? I figure I can keep 1 file in the working directory and just re-write that same file over and over again... I just don't know enough about VB or macros to figure it out.
I am using MS Access to develop a DB application for one of my clients. Now I want to give it my client in a form of .exe file in which he can only use the menubar I have designed. I dont want him to see the MS Access toolbars
Kindly Guide
Is there anyway to create update patches for the access application? If the users are going to use the application for entering data, how can I just provide them update patches for th application if I make some changes in application in future, is it possible in access? I dont want them to change the application by themselves, so I can just make some updates and provide them, without causing any disruption in their datas.
View 3 Replies View RelatedI am using an attendance management system with a DB in Access. Now I want to create APPLICATION_ID automatically by continuing number. For example, I have a table called "LEAVE_APPLICATION" and the structure is below:
EmpID Leave_Type_ID APPLICATION_ID
00360 2 1
00360 2 2
00360 14 3
00360 14 4
00360 8 5
01390 8 1
01390 8 2
01390 14 3
01390 14 4
Now I want to update the table by adding the below data
00360 2
00360 2
01390 14
01390 1
How can i create the APPLICATION_ID field auto generating while pasting additional data. It should be numbering continually from the last record (Grouping to be applied for EmpID)like below:
00360 2 6
00360 2 7
01390 14 5
01390 1 6
Please I have designed an access application and also created a compiled file. But I cannot attach it within code to work from my application.
I need urgent help to achieve that.
Thanks
Peter Chogudo
Hi,
I have a question.
I want to know that how to run mde file without installing MS Access.
Can anybody suggest which application can run the mde file?
Thanks.l
I have this following problem:
I want to program a textbox. In the expression builder of the properties sheet's control source I've programmed this following code:
=IIf([word1] Or [word2]=1,1,0)
It works. But I have to add 37 other "words" and I can not.
I tried:
=IIf([word1] Or [word2]=1,1,0) or =IIf([word3] Or [word4]=1,1,0) Or....
But it doesn't work.
I'm trying to make a simple program to automate timesheet templates. Each of our staff members work on a 4 weekly basis (week 1, week 2, week 3 and week 4). I currently use a word document with the template in and copy and paste it into the timesheet. The timesheets run from the 23rd of one month until the 22nd of the month after. The issue is the four weekly template doesn't fit the same every month so I am after an automated process.
I'm thinking of having forms to select a staff member and change their hours on the template, if you will, and then a button to create new timesheets where admin staff would just need to add the first date (ie 23/09/2013) and the timesheet would be made for each staff member and auto filled with the four week template.
My main issue is I'm not sure how to link the dates to the weeks in a table. I have attached a word template of my own hours.