Hello everyone, new member here. I am in charge of a student sign in sign out database at the college where I work. This database has two forms and one table. What I would like to do is include a text box on the first form, which is the sign in form that will display a running total of the students that are signed in. This text box should count 1, 2, 3 etc. each time a student clicks the sign in button. Thanks for the help
View RepliesThe problem that I have is that when I add a new field to my form at runtime I get the following error
Runtime Error '2424'
The expression you entered has a field, control, or property that Microsoft Access can't find.
This error appears when I try to update any field.
I posted this before and was informed that access has a field counter limit up to 750 on a form, this includes fields which were deleted or hidden. I dont deliberately add and remove fields, but this is the main form in my database so it is not unbelieveable that this may be at the limit and this is why the error is occurring. Does anyone know how to reset this?, or what I should do to get around this.
Thanks
I have a custom record counter on a form using the below code:
Private Sub Form_Current()
If Me.NewRecord Then
Me.lblRecordCounter.Caption = _
"Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount + 1
Else
Me.lblRecordCounter.Caption = _
"Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount
End If
End Sub
I think at some stage the form was saved with a filter on and this may be causing the issue. The problem I have is:
There are 1749 records. Everytime I open the form the custom record counter displays "Record 1 of 501". The built in record counter shows 1 of 1749. The moment I hit the next record arrow the custom record counter displays "2 of 1749" and if I go back again it displays "1 of 1749.".
I know it's a filter causing the problem because I have a macro that does a clear search. As soon as I hit the clear search the custom counter goes back to "1 of 501" again (even though the built in one stays at 1 of 1749).
I have Filter on Load set to No.
what I am doing wrong?
I need Create a new counter on my Customer form for each day, using an Autonumber and print it
View 6 Replies View Relatedhi,
in my table i have a customer id number.
each job will have one customer id number.. and customers will have many jobs to their id
i simply want to display on my form the number of times that customer's id has appeared in my bookings table.
eg.. a customer has used our services 25 times.. (so obviously their customer id is found 25 times in the booking table as a foreign key)
so can i just place a control on my form that displays this value (i presume it is some kind of counter)..
so i will know on my customer form how many times they have been included in a booking record
Hi,
I would like to display a graph in a form along with the fields from a table. The user will be allow to update the table and the graph will be updated. So far I am able to display the graph on the report but I cannot find a way to display the graph on the form. Can somebody help? Thanks in advance.
I would like to put a query or some look up device into my form so that a certain part number can be found and its form opened for changes. How should I do this?
View 1 Replies View RelatedSomewhat simplistic question, but I can't seem to get it to work correctly.
SELECT Field1, Field2
FROM Table1
WHERE Field1 = [Forms]![Form1]![Text1];
Form has two quieries, named Text0 and Text1. Text0 contains the Field info for the query to search under.
How do I change it so that this will work.
SELECT Field1, Field2
FROM Table1
WHERE [Forms]![Form1]![Text0] = [Forms]![Form1]![Text1];
Presently I am getting nothing but blank queries. I'm sure its some simplistic thing but I can't figure it out atm.
Hey there, Im currently making a form so users can enter project information. For this particular project, the user must choose from a variety of options, and each option has a number value assigned to it for a rating. Now at the end of this form, I want a sum of the ratings, and then entered into the table. I am using a text box for the sum of ratings, and can get the sum of ratings to work on the form, but this data is entered as a 0 in the table. If anyone could help me find a way to put the actual sum in the table, that would be excellent.. thx a lot.
If it would be any help, here are the names of text boxes that I'm adding:
Health and Safety Rating, Maintenance Rating, Equipment Rating, School Size Rating, Student Enrollment Rating, SD Priority Rating, Project Requested Previously Rating
Those ratings must be added into "Total Rating"
Thankyou!
I've created a frame but I'm not able to actually to put textboxes inside it, only radio buttons. Is there anyway to force textboxes inside the Frame? Thanks in advanced.
View 1 Replies View RelatedI have On Load, Current, After Update events on a form, which all work fine. But, when I add a Before Update, I get the error: "Procedure declaration does not match description of event or procedure having the same name". Following is my code:
Code:
Private Sub Form_Load()
If InStr(Me.Filter, "=") > 0 Then
If IsNumeric(Mid$(Me.Filter, InStr(Me.Filter, "=") + 1, Len(Me.Filter) - InStr(Me.Filter, "="))) Then
Me.Tag = (Mid$(Me.Filter, InStr(Me.Filter, "=") + 1, Len(Me.Filter) - InStr(Me.Filter, "=")))
End If
End If
[code]....
i have a split form in ms access that has the data source of a linked table in sql server. this form has some fields those are bound to the columns of a table. I want to have a button that would appear in front of each rows. do you know how i can do this?
in a continius form when i will create a button it will be appeared continiously. how can i do this for split form in ms access
I want to build a form that allows a user to book an appointment.
I want them to be able to see a choice of their own or other people's appointments for the day so they can choose a time.
I'm told i can build a query to show the appointments and put that in a subform on the form.
My question is this: to select which person's appointment to display and which day, i need to give the query parameters. I don't really want to do it with the parameter query popups. What i'd like is a couple of pull down lists at the top of the timetable to select and display the person and date.
Is this possible? Should i put the pull down boxes on the form or in the query?
(I'm using a2007)
I want to calculate the average of 16 anodes from text box into the "average drop" box and simultaneously want the data to be saved in the table too as one of the fields. Also, How to load form view while the database loads?
View 10 Replies View RelatedI have an existing database, in whichi I've been asked to implement a counter, of sorts, which could count a store the number of times the database has been opened (including reports being viewed) , in a month. (I'm using access 97). Can this be done? How would I accomplish this?
View 3 Replies View RelatedHello. I'm trying to add a counter to the fields of a query. Purpose is to have a second query choose from this a selected record and next x records, which, of course have been already sorted by first query itself.
I thought the simplest way was with a simple automatic-generated counter, but perhaps I'm making it complicated and there's a simpler way. Any idea?
thanks
Hey guys,
I have a questions for all you experts out there. I need to create a record counter. I have found documentation on how to create a simple record counter, but of course it needs to be a little more complicated than that.
I need to beable to count the records that contain a certain value in a certain field. For example, I need a count on all records which contain the value "Orland" and so on.
I assume this is do able. Just dont know how.
Any help would be appreciated!
Mateo
Hi everyone,
Here is my problem:
I Have a form that shows bills in a continuous form. My problem is that I want to put a textbox or a label that will display a kind of counter for each bills. For example, If I have 3 bills to display, I want my label or textbox to display 1 for the first bill, 2 for the second, 3 for the third, and so on.
But I don't know how to do that with a continuous form.
Could someone help me, please...
Thanks in advance!
I have a counter text box that was set up exactly like the help instructions say to set it up and it is not counting correctly. I have it set up to where it is counting subgroups in the report. It counts for if one record has one or two errors, but I have one record in there that has 3 errors and it says that it only has two errors. Can anyone explain this to me?
learnasugo
a couple of questions...
1) what can i do in order to get a form to open when a database is loaded?
2) what is the automatic counter?
thanks in advance
Hey all, here is my problem. I have a form with my 5 different counters on there and well they are not updating. I can update them on the main page but not on the other pages. I have a page called PID where there are 4 command buttons and counters. I click on the first command button, and add a record there now I would go back to the main page PID and the counter needs to update. How do I do this?? the code I have for to create the counter on the main page is as follows, However I need to enter the building form, and add or delete a record and have the counter on the main page update once finnished with that form. I hope I explained this good enough for someone to help. Thanks in advance.
'Building recordset
On Error Resume Next
If bdg.EOF And bdg.BOF = True Then
bdgcount = 0
Else
With bdg
.MoveFirst
.MoveLast
bdgcount = .RecordCount
End With
End If
Hello all
this is my first post, so i hope i'm in the right bullettin.
I need help with this problem:
I have to work on this mdb that has been imported from Access 2000 to Access 2003. The guys did it some months ago, and of course they deleted the old .mdb and there are no backups.
However, the db still works, except that the ID of some tables are now "random id" than "incremental id", and since they used it for some months, now they are full of new records with random IDs.
Since they use THAT id for internal use, you understand that is not very easy to communicate stuff like "please send me document # -3189175187" and so they asked me to get it back to incremental, i tried from the table menu to change the dropdown, as i thought it was that easy. Bad luck, access now complains that the data aren't now contiguous (might be different error, it's a localized version, so i don't know how it is the exact error message, sorry), and i'm not really sure on what to do to avoid problems.
I've explained the best way i could, so if you need more info just ask, thanks everyone in advance!
Hi - I'm fairly new to Access and have jumped in head first. I do not know much about it, but I am very familiar with the other MS programs. I also don't know anything about visual basic.
I found an article online that described how to put in a custom record counter by using the Oncurrent Event. I have a form with a subform and I'd like have a custom record counter on both, however, when I open a new record, I get an error telling me there is no current record. This is more a problem for the subform, as the message pops up repeatedly until I put something into it to make it a current record.
The error is run-time error '3021': No Current Record.
This is the code that I used (keep in mind that I only copied this and used it, I didn't write it):
Private Sub Form_Current()
' Provide a record counter for using with
' custom navigation buttons (when not using
' Access built in navigation)
Dim rst As DAO.Recordset
Dim lngCount As Long
Set rst = Me.RecordsetClone
With rst
.MoveFirst
.MoveLast
lngCount = .RecordCount
End With
'Show the result of the record count in the text box (txtRecordNo)
Me.txtRecordNo = "Record " & Me.CurrentRecord & " of " & lngCount
End Sub
Any help is appreciated. Thanks!! :D
Hi folks,
can anyone help with what is probally a simple task?
How can I find the Data Type Counter in Access 2003? I am not sure entirely sure if this version is supported, if not what else can I use as a substitute? This is what I am trying to acheive:
http://support.microsoft.com/default.aspx?scid=kb;en-us;245074
I would be greatful of a response.
regards,
Steve
I have an export query that has number of distribution and CM distribution for invoices generated. The objective is to count the number of invoices based on the account number for each customer ID. Since the table has no primary key, the I assigned field number of distribution to 0 in hopes the counter will assign the value of the row number. The attached file shows how the current export displays and how it should display in the highlighted correct way section. I tried COUNT and DCOUNT methods which is the current setup, and they aren't working. This will eliminate the need to go into the file and change the 2 fields.
View 2 Replies View RelatedAfter compacting my Access2000 database it usually is impossible to add new records. The automatic counter does not continue with a new value but seems to have "forgotten" some of the recently added records and tries to use a value that is already allocated. After pressing <ESC> the next value is applied and so - after adding and escaping the appropriate times - it finally reaches a valid new value and the record is accepted. Ugly workaround. Any known solution?
View 2 Replies View Related