Hello everyone ..I really really really really need help with this ..It have to be work but I don know why it’s not working . This is the last thing and I finish my project so if you help me I’ll really appreciate that.
Images and my db Included in my zip
Is there an easy way of doing this? I have a database that I want to automatically place racers as they finish. I have four race divisions. All racers no matter the division start at the same time. I have all of this figured out, but what is getting me is the finish place (1st, 2nd, etc.) Is there a way on a continuos form to automatically place the racers? How this works is...Main form has racer info., on this form is a stop button, and after the button is clicked, it will show his/her finishing place in their division which is subform of the main form. Here is the reason I want this. Someone may have registered wrong and they are in the wrong division, and we have to change them to the correct division after they have finished and already been placed. I want to be able to move them to the right division, and then my subform requery and they placed in the correct position in the new division. Sorry this is so lenghty. Plain and simple can I make a subreport have an unbound field that shows each records place the recordset? Thanks for your help, and like I said sorry this is so long.
View 4 Replies View RelatedHi guys,
I need to finish the Asset Management System I have been creating today.
The main Asset Form works fine for Data Entry. However when I view existing records, the Model of the Asset (I.T Equipment) appears blank.
The reason for this is:
I have three tables linked in the following way:
Manufacturer > Model Group > Model
When an Asset is recorded in the DB, the user must select a Model.
To minimise duplicating data I decided to only store the Model ID in the Asset Table. This way, if I need to view the Manufacturer and Model Group, I can just do a reverse lookup based on the Model ID.
Problem:
The Manufacturer and Model Group are unbound combos. The Model is a bound combo filtered by the Model Group filtered by Manufacturer (aka Cascading Combos).
However, as I am not storing the values for Manufacturer and Model Group in my Asset Table, when viewing existing records, all combo boxes are blank.
Has anyone got a solution to this problem. I downloaded an example by Pat Hartman that requeries the filtered combo on the forms current event. However in that example the main combo was stored in the underlying table.
Any suggestions. Would really like to knock this one on the head today.
Can post an example DB if it would help
Many thanks
BF
Hi,
I have the below in an SQL query that is called by a button (At present) that creates a table with an autonumber Primary Key (Can do a single Autonumber PK or a multiple field PK at the moment with the SQL code), and i want to create a table but the table name (An maybe some fields) to be from a field in the table. How can i do this, and is the below correctly written?? it works OK, but may be untidy.
CREATE TABLE Discharges ( MainID COUNTER CONSTRAINT MainID PRIMARY KEY, DischargeDate1 date,
Program1 varchar, Eligibility1 yesno, Cap1 currency, Phase1 varchar(111),
SRFA1 yesno, DischargeDate2 date, Program2 varchar,
Eligibility2 yesno, Cap2 currency, Phase2 varchar, SRFA2 yesno,
DischargeDate3 date, Program3 varchar, Eligibility3 yesno,
Cap3 currency, Phase3 varchar, SRFA3 yesno, DischargeDate4 date,
Program4 varchar, Eligibility4 yesno, Cap4 currency, Phase4 varchar, SRFA4 yesno, testlabel memo)
Have tried:
CREATE TABLE [Form1].[User] (
CREATE TABLE Form1.User (
and then made the record save (To store the field value on the form) before running the SQL code, but nothing happens (No errors)
Thanks
Dan
I'm using hte Shell() function but this doesn't wait for the executable file to finish so I'm looking for a command line function that would wait until the executable file is finished executing...
I saw this function WaitFor but it is not supported in MS-Access? So, what do I do?
Thanks...
I use Access 2003 and want to make a query by specifying the start and finish within the city, I send files. a
Attached file ...
I have a query that displays the start and finish time for an activity, I am trying to display the reults of the time between each activity....
For example
Name start End
aaa 14:07 14:09
aaa 14:11 14:12
The end time for the first activity was 14:09 and the next job was started at 14:11, so I want it to display 00:02: - (elapsed time)
Its very easy to do in excel as it would be =SUM(B2-C1) but haven't a clue how to do it in access.... is there any way?
I have a subform in which I want to calculate the difference between a start time and finish time, the problem I am having is when the start time is on a different date to the finish time
Start 23:15 on 14th Jan finish 00:015 on 15th Jan, also I want the answer to be the number of minutes. The fields I have are
BatchStartTime Short Time
BatchFinishTime Short Time
BoilTime ([BatchStartTime] - [BatchFinishTime]) General Number.
There are many batches to enter per job and the MainForm has the StartDate as I didn't want to enter the StartDate for each batch.
I am calculating number of weeks between start and finish date. Some of the users have questioned the validity of calculation as they are not too sure if this is being calculated as Monday to Friday week or does it work by calculating 7 days. If the latter is true, then I should see a decimal value. I am using date diff formula.
View 12 Replies View RelatedI am creating a access db for use with a training company. All is working great.
What I want to do is create certificates within Access and then print by the Course load. Easy enough and I can do this.
The courses usually last two or three days, so i want to create a field which has the start and finish date on the certificate formatted correctly.
I currently use this
Code:
CourseDate: DatePart("d",[StartDate]) & " & " & DatePart("d",[EndDate]) & " " & Format([EndDate],"mmmm") & " " & DatePart("yyyy",[EndDate])
within a query which returns this
29 & 30 May 2013
what i want to print on the certificate is this
29th & 30th May 2013
I need to have the 'st' or 'nd' or 'rd' or 'th' in the date.
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.