Search results for query: *

Hi. I was wondering if there's a way to prevent user input if there's already a record in the field. I would like to give an error message something like: MsgBox ("You can't modify this record") on the after update event of a field. What I can think of now is a logic like this. After Update...

Hi. This might sound silly, but what happened was that I wanted to hide a query and a report, so I right-clicked them and changed attribute to "hidden." Then I can't unhide them now. I checked Access Help files and googled a solution, but couldn't find any answer. Can anyone help? Thanks.

Hi. 2 tables are involved in this case. Serial Number Table and Inventory. The naming is not so good, but anyways, the logic is like this: Serial Number Table and Inventory are related by a third field called OrderID. Inventory contains the list of current inventory and availability of each...

I was wondering if there's any way to sort numbers in order in a text table without changing field's data type to Number. I need to have numbers(1st, 2nd,...,50th) and some text options(eg.Returned) together in a field, but I can't sort the numbers in order. Thanks for your reply in advance.

Hi, I have been working in this company as a system developer, working on mainly extensive Access database development. Recently our key accounting staff, who knows SBT(Pro series 6.5) well, quit the company, and my boss wants me to learn SBT and give him the solutions that only IT people can...

Hi. I'm trying the following function to change the background color of a textbox if the date difference between today and expire date is less than 120 days. The form is a continuous form and a textbox to show expiration date is called Expires. Private Sub Form_Current() Dim vDiff As Long...

Hi. I have 5 subforms in a main form (frmMain) and a report. Main form is bound to Main table and each subforms has its bound tables. The child tables and the main table are connected by an ID.(DetID) This form is for calculating expenses for a show. The 5 subforms represent each category of...

Hi. I have a search form with a result listbox. By double clicking an item in the listbox, the main form opens. My problem is that the opened form doesn't have a scroll bar or minimize button. In the form property, they are set to show up, and when I open the form directly, they appear, but by...

Hi. I have 2 txtfields to generate an ID in my form, but they are not working. Here's the code: Private Sub SSpaceH_AfterUpdate() Dim SSpaceW As String, SSpaceH As String SSpaceW = Me!SSpaceW SSpaceH = Me!SSpaceH Select Case (SSpaceW And SSpaceH) Case ("10" And...

HI. I use the following code to open a report from frmMain. stDocName = "rptShowExpenses" DoCmd.OpenReport stDocName, acViewPreview, "[DetID]= " & Me.DetID DetID is a primary key in tblDetail which is a base of frmMain. But, whatever DetID I choose in frmMain, the report...

Hi. I have a search form with 4 unbound text boxes, a command button for search, and a listbox to show search result. When double click the result, a main form(frmMain)opens. The problem is the record on the Main form is locked and wouldn't move to a next record. Here's my code for search...

I have this problem here and there in my database, so I think something fundamental is wrong. One example is my list box to show salesmans in [tblDetail Subform] on OnCurrent event. Here's the code: ListSalesMan.RowSource = "SELECT DISTINCT SalesMan FROM tblSalesMan WHERE DetID = &quot...

Hi. I have a tblContact_Ken with ID, SOURCE, SOLD(YES/NO), LASTDATE. Here's my query: SELECT tblContact_Ken.SOURCE, Count(tblContact_Ken.ID) AS Leads, Round(Count(ID)/(SELECT count(ID) from tblContact_Ken WHERE (((tblContact_Ken.LASTDATE) Between [Start Date] And [End Date])))*100) AS...

I have a frmDetail form which has, among many fields, txtSYear, txtSID, txtSQty, and txtSQty_Last. The tblDetail has SID, SYear, and SQty, among many fields. I want retrieve the SQty of last year from tblDetail to show in frmDetail. For example, if txtSYear on the frmDetail is 2003 and SID is...

Hi. I'm spending days to figure out this. Please help! I have a frmOrder as a subform inside a frmDetail. frmOrder gets values such as DetID automatically from frmDetail. DetID is an autonumber and a primary key in tblDetail which is a base for the frmDetail. What I want to is to dynamically...

Hi. I have a frmOrder as a subform inside a frmDetail. frmOrder gets values such as DetID automatically from frmDetail. DetID is an autonumber and a primary key in tblDetail which is a base for the frmDetail. What I want to is to dynamically change the list in the listbox on frmOrder depending...

Hi. I'm using win 98 and outlook express 6. Outlook Express won't open and gives me a popup window to select an identity(but there is no identity to select) suddenly. I check the registry and found Identity key is not there under HKEY_CURRENT_USER. But, when I open WINDOWS folder and go to...

Hi. I need to creat a show expense database. The shows are usually held once a year. Currently I have about 150 shows. The form I want to build should display showID, name, year, and all other information. After the form is open, a user can select a year to display all information of that...

Hi. I have a table with Lead_ID and Date. I made a query to get total leads per day. This is the query: SELECT MAIN.Date, Count(MAIN.Date) AS Total FROM MAIN GROUP BY MAIN.Date; The result looks like this: Date Total 7/16/2003 6 7/17/2003 9 7/18/2003 12 ...

Hi. Here's my parameter query to get some statistics. SELECT MAIN.[Distributer Name] AS Distributer, MAIN.State AS State, Count(MAIN.ID) AS Leads, Round(Count(ID)/(select count(*) from MAIN)*100) AS Percentage, MAIN.Date FROM MAIN GROUP BY MAIN.[Distributer Name], MAIN.State, MAIN.Date HAVING...