that's exactly what i'm trying to do Seth.
I would be fine if I can only count one field so it's like an overall count based on the filter but it would be cool if I could count any of the fields that I have available.
I just can't seem to get the arguments to work for the expression in the Dcount arguments. I've trie what I thought was putting no expression and it didn't work and I tried putting a "*" as the...
Tyler1394
Last Activity: Aug 29 '16, 08:24 PM
Joined: Jul 25 '16
Location:
-
Tyler1394 started a topic How to Count the number of fields in a form when form is updated or filteredin AccessHow to Count the number of fields in a form when form is updated or filtered
Good afternoon,
I currently have a mainform that acts as my 'maintable' quick access database. there is also a combobox associated with each field in this form.mainform. The combobox's allow you filter through the total records and isolates whatever values are chosen, thus reducing the formlist to a manageable number based on what the combobox inputs are.
I would like to implement code to count the number of records... -
Yeah okay,
So when you make your combobox - grab the values you want to grab from tblroom and it sounds like you'll be grabbing the RoomID as an integer but you can also pass through the names and search it by name.
Regardless,
after you make the combo box, your row source under the data tab in properties should read something like
...Code:SELECT [Roomtbl][RoomID] FROM Roomtbl;
Leave a comment:
-
thank you very much for the help guys !Leave a comment:
-
On your form, create the combo box. Use the combo box to grab information from your tblRoom.
If you only have the 2 tables created individually, you will need to link them together through another table with a relationship.
Once they're linked, you can look up the value from one table, and it will display a linked value in the second table.
your combo box = cbotblRoom '(combo box tblRoom)
...Leave a comment:
-
That is perfect for SQL thanks, I was wondering if there was any of that for general VBA code or even for getting familiar with macros in access?Leave a comment:
-
Disregard,
DoCmd.OpenForm "Sign up form"
DoCmd.GoToRecor d , , acNewRecLeave a comment:
-
What is the code to open a new form upon a commandbutton
I have the code
DoCmd.OpenForm "Formname"
However, when the form opens, I want to GoTo New Record.
This is simple enough as a macro but I'm not sure the syntax for doing it through code. -
I think he means the difference between dates?
Like difference between Feb21 2015 and Feb 22 2016 is 366days kinda?Leave a comment:
-
Thanks for the information,
I guess I realize theres a bunch of ways to do any one task I just don't know the basic communication language between me and the program.
ex.
task = "Select * from MainTableT where " & strCriteria & ""
I've learned to assume the * is the input data but I don't know what the & ____ & does, at first I thought it was string but then...Leave a comment:
-
Turns it only has to be done as a set time everyday,
In which case after playing around with the settings the general export at a set time everyday will work acceptably.
I am curious though,
I tried to export my form datasheet that the 'shift leader' would see - essentially the form that is the face of the 'maintable' table, and upon exporting only about half the fields transferred and access duplicated lots of data....Leave a comment:
-
Any suggestions of where to learn Access?
Good morning,
I have spent the summer learning access to create a database for me work. However, must of this has been brute force attempts and youtube to cover basics of what I need to do. Although this is possible to learn access to a degree there is a wide range of information that I don't have, including general syntax requirements for access.
I have noticed there are many experts on this site and was wondering... -
How To Continuously Update an Excel Spreadsheet at the end of each shift
Good morning,
admittedly have yet to try anything but I have a week left of work and figured i'd throw the question out there while trying to figure it out in case I get nowhere due to my limited coding skills.
I have my main table in the access database that receives information from various forms. At the end of the 'shift' I would like to have any newly acquired records sent to an excel spreadsheet.
... -
Hey guys thanks for the responses.
With Regard to the search box:
Private Sub cboshiftlookup_ AfterUpdate()
Dim myLookup As String
myLookup = " Select * from MainTableT where ([Shift] = " & Me.cboshiftlook up & ")"
Me.MainTableT_s ubform.Form.Rec ordSource = myLookup
Me.MainTableT_s ubform.Form.Req uery
End Sub
I have not tried REFRESH. I'm not...Leave a comment:
-
Need Help on Various Small Issues
I'll be brief:
Issue 1:
I have a combobox search box that allows me to choose from a drop down menu of options. When one item XX is selected, it displays only the records that contain such item XX. however if I clear the search box, the records still show a reduced value of records only containing XX. I would like to return to all records when I clear the search box menu. Any ideas?
Issue 2:
On my form,... -
Thank you very much I appreciate it, i'll work on it and post back here with how it goesLeave a comment:
-
Thanks for the welcome Twinnyfo!
I've attached an image showing what I was able to get to so far (although I realize now that i'm wrong).
From what I had essentially every click would simply update the textbox with the new info (click 9: textbox = 9, click 4: textbox = 4). With that I had no idea how to build up the textbox to say 94 or how I could get the VBA to save the number as a variable to then deal with an operation...Leave a comment:
-
How to create an in form Calculater
I would like to start by saying I have limited programming knowledge except for one university course in C++ that I took 5 years ago. therefore I have an understanding of syntax and how they're supposed to work together but may need help in actually implementing it.
Essentially I have a bunch of different fabrics coming off a line with the possibility of various defects in each fabric. I want the operator to - in a form regarding said...
No activity results to display
Leave a comment: