I Know It's Been Asked Before, But I Can't Find It
Feb 15, 2007
Small project for the local police dept. They want an easy small program to track overtime and who gets it, got it, doesn't want it, etc.
All good, but they want to be able to generate a list (report or on screen) of all those who has received OT and their balance to date, with he/she with the least OT first and ascending from there. In a report I can easily use the sum function in the section footer but how can I sort by that? Or, harder yet, how can I add the numbers in a column in a table/query since the field which contains the "OT hours assigned" will be for each assignment?
So, I guess I need to add a given field value to the other values for a running balance (of coarse this will need to be seperated by each employee).
Thanks
Jim
View Replies
ADVERTISEMENT
Jan 9, 2008
Ok, I reckon there's a gremlin in this damn db...
For a form, i have a series of check boxes. One of these had a & symbol in the name, i originally had this working, but with some extra functionality added it no longer became possible, as it recognised it as a special character. The checkbox, and relating table reference was Inform_Q&FS I changed all references of it to Inform_QFS. However, im getting a parameter window pop up asking for the original reference. I've tracked it down to a point between a button being clicked and the begining of the following forms load Sub. The point of the button method triggering the parameter window is the line where the button changes the subform to the new form.
Here is the db..
Could somebody please take a look and see whats going on... im starting to get really frustrated with databases. :(
Also, any general comments regarding the db are welcome, as i'm assuming im doing things the right way there. and excuse the messy coding
View 4 Replies
View Related
Sep 18, 2005
I have a table with data of people, in which table two fields contain two (not necessarily different) jobs.
I want to build a query (and later a report based on that query) which will return the name, address, phone of the person, plus only the field of the job that I asked for it.
when executing the query, the user should enter the asked job in a popup-box using the below formula.
Like "*" & [job] & "*"
Note, that there may be records containing in both job fields the same job. I want to get the field only if it contains the asked job.
Any ideas?
Thanks
View 12 Replies
View Related
Aug 19, 2004
When you run an Update Query using RunSQL, it always comes up with a box telling you the number of records you are updating and if you want to update. Is there a way to stop this box coming up and just perform the query.
Ed
View 1 Replies
View Related
Jul 28, 2005
I'm not looking for your expertise in "how to" do this (not yet, anyway) but a friend asked me if Access could do certain functions. Like "automatically fill-in some of the
more routine letters/forms such as basic letters of
representation, medical bill/record requests"
(routine for his biz) and "basic calendaring
functions, such as keeping track of monthly deadlines, reminders, and other
important dates."
I figured that if so, the app would have to be running in order track deadlines and such.
So, are these things that are Access able functions?
Tx
-Jim
View 3 Replies
View Related
Nov 13, 2005
Is there a way within this forum I could view all my questions/posts asked at the same time?
Thanks.
View 1 Replies
View Related
Feb 1, 2008
This is probably blindingly obvious but I'm unsure about it.
We'll refer to three tables, call them Table X, Table Y and Table Z.
Basically, I have a database with 10 tables. Table X links to Table Y via the Primary Key. Another field in Table X has a relationship with the Primary Key in Table Z (a foreign key).
Now, does the field in Table X that has a relationship with the primary key in Table Z need to be the primary key as well?
Put another way, does Table X need two primary keys?
View 1 Replies
View Related
Sep 12, 2005
Trying to fix a simple problem with some tables.
In my department, we recently switched servers and from Windows 98 to Windows 2000. We had a database that got converted somehow during the transition. One person didn't get their computer switched until about a month later.
In essence we had 2 databases of the same information going for a while. Now everyone has the same database. Problem is the following:
Simply put:
We have 10,000 records autonumbered in one of the databases. The other database has 9,500 with the last 100 or so being information that the 1st database does not contain. How can I update my main table to have all 10,100 records? I have tried an append query and it doesn't seem to be working right. I have also tried to 'find unmatched' but can't seem to make that work either. There has to be an easy solution to make it work in one step.
Any help would be great. Thanks in advance. :confused:
View 1 Replies
View Related
Mar 26, 2014
I am in the process of making some changes to an inherited database. One of the things I need to do is to fix an issue with the reports. The reports have a field which asks for the data range (from xx/xx/xx to xx/xx/xx) as soon as the report is opened, but then the query that fills that report also asks for the same data range so you end up entering it twice.
What do I need to do to enter the data range only once and have it show up on the report and also be used on the query?
View 3 Replies
View Related
Aug 1, 2014
I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:
Start Date/Time
End Date/Time
Employee
At the moment this is what the format of my report looks like (I removed other unnecessary fields):
StartTime----------EndTime---------------Employee
12/06/2014 01:00--12/06/2014 03:00------John Smith
12/06/2014 04:00--12/06/2014 06:00------Jane Doe
13/06/2014 02:00--13/06/2014 05:00------John Smith
13/06/2014 08:00--13/06/2014 08:00------Jane Doe
I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?
View 2 Replies
View Related
May 23, 2005
A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is.
I've tried it on another machine - also with Access2k - and it's the same.
Is it an Access quirk? Is there an answer? (The client asks why. Be good to be able to say.) Cheers.
View 3 Replies
View Related
Aug 10, 2006
Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number.
Thanks
View 4 Replies
View Related
Apr 25, 2006
I think this is fairly simple, but being as I haven't ever done it! I want to do a search to find all records less those called "Default". As I say I just cant think how to do it. Any help appreciated. Thanks
View 2 Replies
View Related
Apr 6, 2005
Hey everyone,
Im creating a database for college using MS access 2003.
I have 3 table that contain data and i am building form to allow a user to search for a particular customer. The customer ID in my customer table is an auto number.
I have a button on my form and it shows the find and replace box when pressed which is what i want but i then want it so that when a user types a customer ID number in to that find and replace box and it is an exact match for the find and replace box to auto close else show an Error message and allow the user to input another customer number,
Im sure there is macro code to do this so im asking if anyone knows or has any better ideas?
Thanks for your time
View 2 Replies
View Related
Sep 19, 2004
Hello Expert,
I have attempted for two days to following codes. I am still unable to get the way out. Would you give me a help?
The field fund_cd is a combo box of transaction table to look up reference table called fund_type. Here is the structure of fund_type:
fund_cd text 3
fund_desc text 50
fund_currency text 5
My needs are to pull both values of fund_cd and fund_currency to transaction table, so 1 combo box cannot meet my needs. As such, I write following codes to base on selected fund_cd to find appropriate value of fund_currency in fund_type.
From the code below, I meet the run-time error ‘3001’ and I am not sure can I finally get fund_currency using method of GetString.
Dim strSQL As String
Dim strccy As String
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenStatic
rst.Open "Select * from fund_type"
strSQL = "fund_cd = " & Me.fund_cd
rst.MoveFirst
rst.Find strSQL, 0, adSearchForward
strccy = rst.GetString(adClipString)
Thanks very much!
martinaccess
View 1 Replies
View Related
Dec 24, 2004
I am trying to code a combo box control to find a record. This is incredibly simple but for some reason it won't work. Could you tell me what I am missing.
I have put the following code in the after update of the control
Dim rs as Object
Set rs= Me.Recordset.Clone
rs.FindFirst "[ContestNo]='"&Me![Combo23] & "'"
Me.Bookmark=rs.Bookmark
I don't get any errors but it won't work either...any ideas??
thanks in advance,
Brenda
View 2 Replies
View Related
Feb 1, 2005
I have an unbound text box. I want the user to
be able to type in all or part of a title for a movie.
Hit the find button and then have a form open
with entry's based on the text box.
Thanks Tukewa
View 2 Replies
View Related
Aug 17, 2005
Hello to all,
Little new in Access i would like to know how to use the key to find directly to a record in a table.
ie : i have a table where the primary key (unique) is a date, using VBA i would like to know the instruction to find directly the record 01/06/2004 for exemple.
Thanks in advance.
VINCENT
View 2 Replies
View Related
Sep 27, 2005
I realize this probably isn't the right place for this, but...how do I find all of my posts, whether I started a new post or responded to someone else's post?
Thanks in advance to whoever replies :D
View 2 Replies
View Related
Mar 7, 2006
I have a find command button that appears to call the find and replace message box. It should be a search for anything in my query. The code behind the button looks like the find and replace message box in the office suite. I believe I am trying to create a message box where you add an entry and it searches then lauches a subform with my entries.
When I checked the button it had the following code:
Private Sub cmdFind_Click()
On Error GoTo Err_cmdFind_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdFind_Click:
Exit Sub
Err_cmdFind_Click:
MsgBox Err.Description
Resume Exit_cmdFind_Click
End Sub
I read a few of the lookup queries but they only give me a drop down. Is there some way to customize the box comes up without altering all of Office or do I just sound lost.
View 1 Replies
View Related
Jun 1, 2006
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the Access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.
View 1 Replies
View Related
Jun 1, 2006
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.
View 1 Replies
View Related
Jan 24, 2007
Hi all
This message has suddenly started to appear when clicking on a shortcut to all my mdbs.
Windows cannot find [path] .mdb
I click OK and the db continues normally.
the message does not appear when opening a mdb directly.
odd huh?
any thoughts on how to resolve this annoying problem would be appreciated
View 1 Replies
View Related
Jun 21, 2007
Hi, I am inputing addresses into a massive databse, through a form, does anyone know a way, that i can get it to do a search for the address based on the postcode, like how googlemaps does it or something?
Thanks
Alex
View 2 Replies
View Related
Aug 21, 2007
I have some database, I need to replace empty cells one column with some data.
But Access does not do it.
Any suggestions?
View 1 Replies
View Related
Jan 14, 2008
I need to add a Form to an Access database designed by others. In the form design view, there is no toolbox shown . If I go to View menu, toolbox is greyed out.
Can anyone please advise how to locate the toolbox?
View 2 Replies
View Related