Search results

Thanks I'll give it a try

Hello all: Does anyone have any idea how to recover a lost MS Access 2000 file? I accidently deleted it from our file server and of course it can't be found in the Recycle Bin. Running a Win 2003 platform. Any suggestions would be greatly appreciated. Nate

Your second suggestion worked but it did'nt do what I wanted it to do. Instead it is querying duplicate User Names. It should be listing all users. I am thinking of just merging the 2 tables together for now so I can run a report of a query. Thanks for you help though.

Ok there are 4 tables i need to draw information from. Dept, Employee, Desktop and Laptop I need to draw Dept ID from Dept, User Name from Employee and then Make Model, Date Purchased and Value from the Desktop and Laptop tables. These 2 tables unfortunately have the exact same field names...

Sure Select * From Desktop Table Union ALL Select * From Laptop Table FROM [Department Table] INNER JOIN (([Employee Table] INNER JOIN [Desktop Table] ON [Employee Table].[User Name] = [Desktop Table].[User Name]) INNER JOIN [Laptop Table] ON [Employee Table].[User Name] = [Laptop...

I have tried different variations but am getting an error in the FROM clause.

I have 3 tables called: Dept_Name D_Table L_Table I have duplicate field names for D_Table and L_Table called: Make_Model Date_Purchased Invoice_Total I am trying to create a query (eventually a report) that lists the Dept_ID (from Dept_Name) the Make_Model, Date_Purchased and...

Sorry Wayne, even though the zipped file is 504 bytes I can't attach it to the posting. It says it's too big! I will try again this afternoon. Thanks

Private Sub Detail_Click() If Me.Make_Model = "KTX" Then Me.Check28.Enabled = True Else Me.Check28.Enabled = False End If End Sub This still does not seem to work? :confused: Thank you for the advice, but it still does not seem to work. The check box does not disable at all. Nate

Thanks Wayne: I think I understand but my code does not seem to work. Am I just inserting the code anywhere in the VB program? Here is a look at what I have code---------------------------------------------------------------------------- Form OnCurrent If Form_DesktopAdd / Modify /...

Is it possible through simple VB code to have a label and respective check box enabled or disabled when a specific string pops up in a text box. I have a text box that contains computer models. When viewing the records I would like the check box and label to be grayed out unless KTX is in...

Sure, Desktop Table contains 9 Columns: Computer_Name User_Name Make/Model HD_Mem RAM Processor Invoice_Date Invoice_Amount Serial_Number Department Table contains 2 Columns: Dept_Name Dept_ID Again I am trying to create a report with Dept_Name as the heading and have all the data in...

I am trying to create a report that displays data from 2 different tables(Desktop & Department) and have them grouped under a Department Heading. When I create this and run the report 20 or so records do not show up on the report. However, when I try to create a report using only the one table...

Yes Pat I wanted to hide the duplicate fields but I guess thats not possible. Thanks for all your helps guys! :)

I have a table with 8 entries which repeat over and over again (Monitor Make) I am trying to create a query that eliminates all of the repetitive entries, so instead of displaying 250 of the same Monitor Make I would like it to just display the 8. Simply put, I would like to eliminate the...

Got Focus Worked! Thanks for you help, this forum rocks:cool:

I am trying to create a Msg Box that pops up when the user clicks on a text field. I just want to prompt the user let them hit ok and then carry on their entry, I know I have to add: Private Sub OnClick() MsgBox "Good morning, ", vbOKOnly End Sub or something like that but I can't get...

Removing the brackets was also a failure. I have given up on the list boxes and moved onto the Combo Box and it seems to be working fine. Thanks for your help guys!

Even after removing the = sign in the Control Source it still does'nt work

Here is the field's control source: =[Dept ID] Here is the field's rowsource: SELECT [Dept ID for Employee Table].[Dept ID] FROM [Dept ID for Employee Table]; And Row Source Type is: Table/Query Again, the Dept_ID and Office_ID fields will not update when I try to add...