I can take the code in case 2 out (only the code, leaving the case 2) and it will work or I can take out the code in case 1 and it will work. Does not matter which code is with which case as long as it is only 1 piece of coding in the select case it will work.
Ignacious
I have the following code behind a command button of an option group that has 2 radio buttons. Case 1 or case 2 will work by themselves but as soon as both are in the code clicking the command button does nothing not even an error code..
Private Sub cmdAddTo_Click()
Dim RS As DAO.Recordset...
I have been using VBA and recently started programming in VB6. I have created the menu bar with file and help as top level menus. I have created an about form to open under the help menu but am having trouble getting the coding correct to make the about form "popup" when the about menu item is...
I use a database to assign in shop part numbers to items. On my data entry form I have a subform that shows the last serial number assigned from a query against the table. I also have a command button to enter another record instead of closing and re-opening the form. I am having a problem...
I just split a database on my hard drive then moved it to the server. Everything works fine on my hard drive, but once on the server none of the reports, queries, etc. work because Acess puts the database path in the properties of the linked tables and this path is on my hard drive not the one...
I have an access database with DateReceived and DateCompleted box's.
I need to ensure that the date entered in the DateCompleted box is the same or later than the DateReceived box.
Thanks
Ignacious
I will try to be a little more specific. In the table I have
FieldName
Item1
Item2
I need to create a query or report to count how many of each item is listed in the FieldName. So then I would have a report that shows the quantity of each.
I am trying to get a report, with a count, from a particular field in a table that has two possible entries.
FieldName
Item1
Item2
I would like to know how many of each item there is
Item1 = X
Item2 = X
Thank you
Ignacious
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.