I have a custom command button cmdPreviousRec and cmdNextRec for navigation, but when i click the cmdPreviousRec its not navigating to the records and the cmdNextRec is up to 2nd record only.
Code below is the i've working:
Private Sub cmdNextRec_Click()
On Error Resume Next
Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT * FROM tblAMHMace")
If Not rs.EOF Then
rs.MoveNext
[Code] ....
I have made an access database for doing inventory at work. We have an inventory of approx. 700 items that need to be counted each month. I have a subform that is in datasheet view, it has Inventory IDs, product descriptions, UOMs, and a field to enter quantities. On the parent form are pictures and extra descriptions linked to each item in the subform.
The Inventory IDs all start with a 3 letter alpha code for which class of item they are PLU for plumbing, FAS for fasteners, ELD for electrical device, etc. There are about 15 different classes of these inventory items. The rest of the InvIDs are 4 digits: (PLU5453 or ELD1123)
We are using tablets to do the inventory counts, so to search for an item we can swipe through the datasheet to find the InvIDs we are looking for and then enter the quantity. After our initial inventory my supervisor asked if I could add buttons to jump to the first item in a particular class of item such as PLU0001. He showed me his address book in his phone as an example, how he can push a P button to bring him to the first name that starts with P.
I considered tabs for each class, but he wants to navigate to other items by just swiping also. I tried to make a Macro that would use Go To Record but was unable to make that work.
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
View 2 Replies View RelatedHello,
I need to navigate through all records for a table where a <field> = a certain "string". Ideally I would have a next record button that would know to ignore records that do not meet my criteria?
Simply put,
Next available record where <field> = "string"?
Is there anyway to do this?
Regards,
Chris
I have a form that reads records from a query.. It loads the first record into the form, without issue.
Code:
Sub FormLoaded()
Dim r As DAO.Recordset
Set r = CurrentDb.OpenRecordset("Results") ' Query we want
Forms("frmmainnew").lbladdUser1bad.Visible = False
[Code] ....
Now I have have 2 buttons at the bottom of the form, one for next record and another for previous record...
Code for next record
Sub NextRecordbtn()
Dim r As DAO.Recordset
Set r = CurrentDb.OpenRecordset("Results") ' Query we want
r.MoveNext
If r.EOF = True Then
[Code] ....
I know that I have 3 records that result in the query named "Results", the next record button will bring the form from record 1, to record 2... however it will not move from the 2nd to the 3rd record...
Hi all, complete Access n00b here requiring some assistance if possible with the dreaded cascading combos. Would appreciate any help I can get. I've tried searching but can't find this particular problem mentioned (am probably searching for the wrong thing, but anyway...) Here is my situation:
I have a form [Component] with a simple cascading combo box scenario [cboCategory] and [cboSubcategory].
[cboCategory] has as its row source -
SELECT tblCategory.categoryid, tblCategory.Category FROM tblCategory ORDER BY tblCategory.Category;
Control source is unbound.
I have Me.cboSubcategory.Requery as an afterupdate event.
[cboSubcategory]'s row source is -
SELECT tblSubcategory.subcategoryid, tblSubcategory.subcategory FROM tblSubcategory WHERE tblSubcategory.Categoryid=Forms!Component!cboCateg ory ORDER BY tblSubcategory.Subcategory;
Control source is bound to SubcategoryID in tblComponent.
I have set up [tblCategory] as the one side of a one to many relationship with [tblSubcategory] and [tblSubcategory] as the one side of a one to many relationship with [tblComponent]. [SubcategoryID] (foreign key) is the only piece of 'category' information I am storing in [tblComponent]. I presume that's the correct thing to do since you can calculate the category from the stored subcategoryID.
The problem is that the form only seems to remember the most recent combo choice so if i fill in one record, navigate to another use the combos again, then navigate back, the original combo choice has been overwritten in the form record (although the underlying tblComponent seems to have the correct data written to it). In other words ALL records on my form display the last values that were entered using the combo boxes and not the correct values. Is this normal? I hope not, and if not then what am I doing wrong?
Thanks in advance :)
I am a newbie at Access and I am currently learning it for my job...I have a database going and I am wanting to do two things and I can not figure it out for the life of me.
Little background, the database I made is a continuous form. I am wanting a command button that when pushed will put it in data entry mode, and when pressed again will put back in a 'view all' state. I know it is a simple If Then, but I don't know VBA very well =
Other thing, is I wanting to be able have button that when pressed will output to an excel sheet, right now I have it when it is pressed it asks me what kind of format I want outputted, and I want it automated to just go straight to excel.
Any help would be appreciated, thanks.
How do I make the command buttons on my form actually do something, the only one that attempts to work is "DELETE RECORD" the others dont do anything at all
View 8 Replies View RelatedI want to create a new database which has a startup form that has 4 command buttons.. My problem is that I want that every click of the command buttons will take me to the main switchboard of the other/different database.. How am I going to link those buttons to different databases?:confused:
anyone help me?:(
I know how to change the color of the font of the command button, but saw nothing in properties on how to change the color of the button... is this at all possible. If you need a reason, it is for designing preference really.
View 1 Replies View Relatedhey, i have a form which uses one table only which is for purchases. it has 4 fields:
memberID:
productID:
quantity:
date:
and then it has a button - "Add Another Purchase" which confirms the purchase.
However, I want the stock number in tblProducts to decrease by the quantity whenever that button is pressed. I have tried using MS visual basics to enter a code but i dont think he "Stock number" is recognised, as it is in a different table to the one i used for my form. (i have linked the two tables, however)
any solutions????????
hello.. i want my form to look like this:
http://i114.photobucket.com/albums/n258/lushh_16/employeeform.jpg
where there is add, edit, save and delete buttons.. and that the record cannot be edited unless the "Edit button" is clicked and the entry will only be saved when the "Save" button is clicked. i tried to search for sample databases, but it doesn't inlcude a sample of this. thank you so much...
Hi, I am having troubles with adding command buttons on to my form.
I have created a new form and used the wizard to create a command button
with Cancel (which i just want to click on and the form closes). but when I am done the
button doesnt work. can someone give me instruction or tell me what the heck i
am doing wrong. thanks
I want to create a new database which has a startup form that has 4 command buttons.. My problem is that I want that every click of the command buttons will take me to the main switchboard of the other/different database.. How am I going to link those buttons to different databases?
anyone help me?
I'm running Access 2000 and want to use some different icons than available through Access on some command buttons. So far, I can only get it to accept bitmaps. This isn't a problem if bitmaps can have a transparency. I don't think they can though. Any suggestions?
The icons I want to use have a transparency.
Thank you,
alteque
I have a form listing clients. Each has a command button linking to another form with client details and other option. One the bottom of the form is an Add Client button. I want the user to only be able to add a max of 6 clients, and the buttons to these clients be invisible until the Add Client button is pressed and the information about the client is filled out. Then back on main form listing clients, the client name will appear with a command button that will link to client details. How can this be done? I've seen it done, but can't figure it out.
tritonvt
Is it possible to have a command button that UNDO's the informations filled out on a form and closes the form?
View 3 Replies View RelatedWhat I want to do it when the report is generated and opened in a preivew mode, I want to give the user the options to:Save the report, Print the report or Email the report. How can I add these three buttons to the report?
View 10 Replies View RelatedHello
I have created a form in Access 2003 based on a query, the form has a sub form( basically the form shows different projects, the sub form shows the stages of the project, one project can have many different stages). I want to put a command button to add a new record for the data in a sub form, I have managed to create one for the main form, but not the sub form.
I would appreciate any help, thanks
Please can you help
Hi all,
I'm having a problem trying to get some code to work that a member of this forum helped me with some years ago. Basically I have a form with a combobox that is used to select the user name and a textbox for the password to be entered. There are two different types of user, manager and clerk. The logon button must open the selection screen form but if the user is a clerk, then the delete client command button must be disabled.
I keep getting a 'Compile Error stating Block If without End If' and I'm not sure where I'm going wrong.
I'm also not sure what code I should be writing to disable the command button dependant on user.
I know this is not great security, but it's only going to be used as an interim solution for 4 people (none with access experience). Can anyone please explain to me why I'm getting the compile error and what code I would need to disable the command button on the form and where I would need to put it.
Many thanks.
Here is the code:
If Me.Password = Me.Combo10.Column(4) Then
If Combo10.Column(3) = "Manager" Then
DoCmd.OpenForm "frm_Splash_Screen"
ElseIf Me.Password = Me.Combo10.Column(4) Then
If Combo10.Column(3) = "Clerk" Then
DoCmd.OpenForm "frm_Splash_Screen"
End If
Else
Msgbox "Incorrect Password, try again"
End if
Was woundering if the was a way to habdle multiple command buttons with one procedure. I have done a little VB.Net and I remember that you coud use one sub to handle multiple buttons using the handles key word. I was wondering if Access could do that. What I have is 37 command buttons named cmdView1 through cmdView37 all I really need is the number that prefixes the command buttons name. I know how to pull out the number but I can not figure out how to use only one sub procedure for all 37 buttons. Any help is appreciated.
Frank
Hi...total newbie here trying to get out of the blocks!
I want to be able to open forms with a button and filter in the process.
I have Customer details in a table
I have Site details in a table
I have Product details in a table
From my 'frmCustomer' I want to hit a comand button to open 'frmSite' and filter only the records related to that customer, then from my 'frmSites' hit a command button to open 'frmProducts' filterd by that site.
Please help, driving me mad!
I have a form that contains a subform.
The subform is bound to a table.
The form is based on a query but still writes directly to the appropriate table.
In the header of the form I have a series of command buttons - new record, navigation buttons, and buttons to open new forms. None of them work at all.
I checked each button to be sure the On Click Events still had the right Event procedure, and they do.
for example, the command button to open the Cases form has the following VBA (generated form the button wizard.):
Private Sub cmdOpenCases_Click()
On Error GoTo Err_cmdOpenCases_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmCases"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmdOpenCases_Click:
Exit Sub
Err_cmdOpenCases_Click:
MsgBox Err.Description
Resume Exit_cmdOpenCases_Click
End Sub
When clicked, the button just blinks - nothing happens. I check to be sure the form isn't a popup and also closed it after clicking it to see if maybe frmCases had opened behind the current form for some reason. Nothing - it's not opening at all.
Any ideas?
Is it possible to put a command button on a report? I can't do any kind of programming so only use the command button wizards.
I'd like to have a button to click on in order to print or close the report, rather than use the menu bar.
Is this possible, easily?
Thanks very much.