Hi
I am using the following code to create a csv file on the desktop using a query
Set wShell = CreateObject("WScript.Shell")
path = wShell.SpecialFolders("Desktop")
Set wShell = Nothing
DoCmd.TransferText acExportDelim, , "qryexportcsv", path + "export" & Format(Now(), "ddmmyyyy_HH:MM:SS") & ".csv", True
Could someone tell me how I would also make a copy of the file in the root directory in the same event.
Thanks
Rob
I am using the Packaging Wizard of the MS Office Access 2003 Developer Extensions. I would like to change the Root Installation folder to a customer Folder. However, I am limited to the list given (Program Files, Documents & Settings, etc..). I even tried to see if I could change the INI files produced by the package, but could not find any reference to the root installation folder. Does anyone know how to change this, either through the wizard or manually.
I know I can have the user move the folder once the install is complete, but I do not with to do this.
I need to get an average repair price of multiple part numbers with the same root number i.e.
8 each 8TJ124GGN1
4 each 8TJ124GGM1
7 each 8TJ124GGP1
First I used a query to average the repair price of each subset of numbers, and then queried the query to average all the subset prices together.
If I simply use the AVG function in the first query, I can use it again in the second query to get the average price of all the subset price averages. HOWEVER, if I use the expression:
AdjustedAvgLabor: Int((Sum([LaborPrice])-Max([LaborPrice])- Min([LaborPrice]))/(Count([LaborPrice])-2))
…to get a more accurate average by throwing out the high and low values, I get a:
“…expression too complicated to be evaluated”
when I try to average the averages in the second query using the AVG function.
I don’t know why the expression is “too complicated” since the first query has already completed its computations before the second query begins its AVG function.
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
View 1 Replies View RelatedI created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
View 7 Replies View Relateda system for my company. I have been working with Access for a total of 3 days now, so bear with my inexperience.I have a table with State, Product Name, and so on as Column headers. I have repetition in both of those Columns (if that matters). I would like to figure out how to be able to pull up (Search, Sort, not sure how to word it) 1. By state) all products offered in that state and related info2. By Product) all states using the selected product and related infoWhich would be better for the above goals - Form or Page?I have looked into cascading combo boxes....it that the right direction?
View 2 Replies View RelatedI have a table of around 100,000 records all with a unique contract ID. However there are several entries holding different information on each line but with the same contract number. How can I assign each contract number with its own ID for example contract number 12345 has 6 different entries in the system which i need to keep but i want to assign that contract number with its own ID so i can provide a better contract count instead of it appearing 6 times.
View 1 Replies View RelatedI use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didnt work.
This is what I got:
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
So installed office XP and tried the same steps but still not working.
I have created access2K application with 4 clients (forms+query+macro+reports) residing on workstations and database on server. I have created MDE of 3 frontends but unable to do so on one computer. When I goto Tools->Database Utilities->Make MDE File... (Disabled)
Its disabled I cannot continue so no error message. Any idea?
Prodigy
I would like to create a new folder with a specific name.
example
I have a k: drive where i want the new folder created
I want to name the new folder under the k: drive.
Im sure this is very easy to do, but i can't seem to find an example in the forum.
thanks in advance
I would like to create a new database from an existing data base with the same fields but I don't want the data. Can anyone give me a step-by step instruction. I also want to duplicate the form as well.
I am currently using ACCESS 2000
Hi,
I have two tables i would like to create a relationship with but the two fields that i want to join are not exactly the same e.g
Table 1
0000111111
Table 2
111111 ABC
The key piece of information that i would like to link together is the 111111, in SQL i would just type "WHERE Code LIKE '*111111*'" or something like that.
Is there anyway i can create a relationship based on the data above?
Many thanks
Tim
I am trying to use the following code to export a table into a new spreadsheet that does not exist yet:
DoCmd.TransferSpreadsheet acExport, tbl_temp, "C:Spreadsheets" & rst!clientid & ".xls", True
but it won't work because the spreadsheet doesn't exist. How can I make Access create the spreadsheet?
Thanks in advance!
Vassago
Can MS Access do "create view"?
CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;
When I put it in the SQL View in the query, it does NOT run.
I put it in modules, it doesn't run, too.
Thanks.
This has got to be a really easy one for you guys...!
I need to record the date/time a record was created - I've tried to use now() but obviously that updates and there appears to be no function for create date...
Can someone help me out please?
Thanks!
Katie
I setup my security (or lack there of, hehe) and split the database. I relinked the tables.
Now, Access gets hung up when I try to create an MDE of the FE to distribute. It starts the process, asking me to select a folder and file name, I do that, and it gets no further in the process. Access says (not responding).
Should I have created the MDE before I split it? Or does crashing of Access have nothing to do with whether i create the MDE before or after splitting?
Hi All.
I have searched forums......honest!! But cannot find an answer.
I have the following code to make a directory....the directory name is as the ID_number....
---------------------------------------------------
Private Sub Command216_Click()
Dim strDirectoryPath1 As String
strDirectoryPath1 = "\server1Helpdesk_Calls" + CStr(Me.ID_Number)
If Len(Dir$(strDirectoryPath1 & ".", vbDirectory)) <> 0 Then
MsgBox "The project folder already exists, the folder will now open"
stAppName = "C:Windowsexplorer.exe \server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
Else
MkDir (strDirectoryPath1)
MsgBox "A folder has been created on the network at location \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
stAppName = "C:Windowsexplorer.exe \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
End If
End Sub
------------------------------------------------
This works fine, and makes a directory on the network drive i.e
\server1helpdesk_calls123456
My question is, how do I also make it create directories under this one i.e
\server1helpdesk_calls123456Emails
It is the ID_number that is throwing me....have tried with numerous goes!!
Many Thanks.
Frank.
Is there any way of adding export fuction to the toolbar using modules or macro
or how I can build my own toolbar when will appear in all workstation in the company
Structure of db
tables
divs(divid, div, div_short, div_num)
subdivs ( subdivid, divid, subdiv)
issues (issueID, issue, issueName, subdivid)
subIssue1 (subissueID, subissue, issueid)
subIssue2 (subissue2id, subissue2, issueid)
resolution (resID, labeltext, subIssueID)
resolutionlink( resID, labeltext, linktext, navURL, suIssueID)
relationships
div and subdiv (1 to many)
subdiv and issues (1 to many)
issues and subIssue1 (1 to many)
subIssue1 and subIssue2 (1 to many)
Now resolution table could have a one to many relationship with either issue table, subIssue1 table, or subIssue2 table. When I go to create any of those relationships, Access won't allow me. Tells me it can't create this relationship and enforce referential integrity.
Possibly I need to restructure my database to accomodate?
I am not sure, any help would be appreciated.
Could someone please help me with the following problem.
I have a report that downloads into excel from a loan software program.
The report has lots of data for each individual loan number
What I have done is link this report to access as a table.
The problem I am having is how do I create a relationship with that table.
I want to create a status report that does the following
There are about 15 steps in the loan process, and I want to add 3 fields to link to every loan number (possibly a subform)
description of event
is it completed(y or n)
date completed
can someone please help me with any ideas
thanks
Josh
I have a database for call outs, i had a problem with double booking, but cured that, my problem now is every time my work mates try to book me in that go into the debug box (accidently) all i need is a ok button only msgbox to say the time is already booked. can anyone plaease help.
here is my db if any one want to have a look
I need to create a database for students going on work experience.
Each of the students will have a rating from 1-6 depending on behaviour, effort and attainment. Each of the work placements also has a rating from 1-6. Each student chooses 6 work placements that they would like to attend (one of each rating)
If all the data for the students and the workplacements are entered into the system is it possible to match appropriate students to appropriate workplacements using MS Access 2003?
I am developing a database which will track some of my companies clients bonus trips. Basically everyone is going to the same place but folks are of different levels. Level A is a 14 day trip with X number of activities, Level B is a 10 day trip with Y number of activities and so on. The major things I'll have to track are all of their personal information as well as 'Air Travel', 'Hotel Stay', and 'Recreational Activities' information.
I can put all of this information in to one table (tblTraveler), or am I better off with creating tblTraveler holding only personal information and then linking to other tables such as tblAir, tblHotel, and so on? I'm not entirely new to Access, but no pro yet for sure. Only problem with creating one table is that it would have one whole lotta fields. Not sure if it's better developing technique to split everything up.
Also, the only thing I can come up with as a primary key is the people's last names. The client numbers are the same on many of them, so that's the only thing I can come up with. The PK really is only a factor if it's best to create multiple tables for the traveler. At first I thought it was best to split everything, but now I'm seeing less reason to take all of the travelers information and dump in seperate tables since most of the time on the master reports the trip planners want everything lumped together. Perhaps I'm better off just keeping the forms clean and seperate and just one table? The reports will do the rest for me. Any input greatly appreciated.
Hi:
In query, how can I make table when there is Union
eg.
(SELECT *
FROM table1
UNION select *
from table2) into combine;
It doesn't work.
How can I fix that?
hello!this is my first time in this forum
i hope you can help me with this...
i created a database wich has one table with many fields, what i need is a parameter query to sort the information on that table, the problem is that i want the user to decide wich fields he needs, and if he want to use parameters (criteria) or not on those fields he choose, i wanna now if this is posible with just one query instead of one for each combination of fields the user wants on his query. i hope i make myself clear if i dont just let me know
oh and the criteria is taken from comboboxes in a form, and the query is runned from a comand button on that form too.
thank you
In database is one Table, where are only two fields (ID and Text):
ID Text
1 AA
2 BB
3 AA
4 CC
5 EE
And in a form I have TexBox where is a text string, for ex. : aa; cc; ee
Im trying to create Query which find all records from Table which contains
"aa" or "cc" or "ee".
If I use concrete values in Query, it works :
SELECT * FROM Table WHERE (((Table.text) In ("aa","cc,ee")));
but when I use refer to a TextBox it doesn't works :(:
SELECT * FROM Table WHERE (((Table.text) In ([TexBox])));
Because it will do [TextBox]="aa;cc;ee" and not "aa";"cc";"ee"
Can anyone help me with it?
Thank you and have nice day.
Jira