I'm working on tring to update a Date using Vb. I keep getting an Error in my Update command
CurrentDb.Execute ("UPDATE Tbl_ReportTool SET Date = ' & ![bill date] & ' WHERE ID = '1'")
I...
I have a subform showing a list of records and an associated number value (any # from 1-5). The goal is that the user can select a combo box (or another control) with #s 1-5 which would becom...
Hi,
I have Excel spread sheet with Cust_ID, Name and Address Column.
Cust_ID is unique but ther are multiple records for Name and Address..
How do I get Unique record please ??????
I want...
I'm having difficulty deleting multiple records (one after the other) using a command button on my form. The first delete works as expected, but when I click the delete button a second time, n...
Sorry if I'm rubbish at explaining this but I've got a database, screenshots attached, which has a subform on 2 tabs within the main form - the subform is split over the 2 tabs into 2 seperate...
In my Microsoft Access database, I have a search form with the following specifications (also see attached snapshot):
At the top - I have two search fields (last name and first name). If us...
hi,
I have trouble filtering data in the subform. There are 4 combo boxes in the main form named "CATDATA" and the subform's name is "sfrProjectList". I have a Filter command button named cm...
FormA (switchboard) field1 are JobOrders field2 are subJobOrders
field1 field2
cbobox ...
Hello,
I am working on a form in access.
I enter an item number and a few other txtboxes are filled automatically.
One of txtboxes is a date. Another txtbox is a number for number of days.
...
hi experts :)
hopefully someone would be kind enough to help me with this problem
i have records in a table where i have a group of names seperated by a ; symbol.
what i need to be ab...
Ok, so I posted my db as that is probably the only way you can help me is to look at it.
The forms that have the issue are AS9100RequirementAdd and CMMIRequirementAdd.
So for me, being my fi...
I have a form on a tab (frm_Notes) which allows for the entry of notes, which are timestamped. The user enters one note at a time. I have a command button which allows the user to open another...
I don't know if this is possible but within my database I have a table with items that users will select from a combobox. However the most popular need to be at the top of the combobox list an...
I am working on a form that has a tab set with connections to multiple tables (one per tab) that is connected to the primary screen by the company no. Each tab has a table connected via the C...
I have a table called productTbl with severel fields including an item# field, memo (descriptive) field and an updated (date ) field. Every day I import an updated productTbl from our website...
In a case where I have form A open in design mode and need to copy code from form A to form B, form B opens in design mode behind form A. That irritates me to the Nth degree. Is there any wa...
Hello Experts,
I am coding in VBA for MS Access. I have few message boxes that pops up in my application. However it seems the message boxes aren't that informative since they all look alik...
(in Access 2000) in my form I have this field where people have to enter a phone number. I set up an input mask (the phone input mask, obviously) in that field, but now I have a new problem....
I have created Tables, Query and Form in Access 2007, is there anyway a user can search for a record and then copy that record by pressing say a new button to get a new record, eg the same inf...
I have a combo box on my Access 2003 form. It is filled by data via a stored procedure. The procedure returns an ID and the String. The string is only visible in the Combo Box. The ID is not s...
How do I perform a textbox.requery when a change occurs in another control? I've can go to change and click and put code in. The problem is when the navigation controls are used. As the use...
I am in the process of transfering out database from an Access backend to an SQL backend linked to an access front end.
All is going well apart from 1 problem, i have this code =DCount("*",...
I was asked to adjust some forms for a friend, and I've run into a problem that I don't have the slightest idea what to do.
The form is a small one with 10 fields or so. Just entries and 4 c...
Hi,
I have a form called frmPatients that has a grid what I want is when the user click on the grid
I should call frmPatientDetail for that specific record.
I did this but it's not work...
I have a form that displays the support staff for a client. If the support staff leaves I would still like the name to show when the client is pulled up. But I don't want it to show in the d...
