Search results for query: *

Hi: I have a very small database in Access 97 with just 3 tables, all related. All I need to do is print a relationship diagram to show my boss, but I cannot get a print preview screen or the design mode of my relationship window. Any ideas would bew greatly appreciated. Thanks JD

Thank you both very much...both ways worked perfect!!!

Hi: I am making a report where one of my fields comes from an "if" expression in my query. It simply prints out "yes" or "no" in the report detail for each entry. What I would like to do if have a count total of yes's and no's in my report footer, but I am not sure how to do so. Any help...

Thanks for the help. I will try this out when I get home! Josh

Hi, I am helping a small business owner set up a very small network, 2 computers, both running XP pro. I have just set them up with a small 4 port router. My problem is that when I copy files from one PC to the other, many of them large media files, the folder sizes more than double on the...

Worked perfect...Thanks!!!!

This should be easy...I have a calendar form to input a date into a particular field on a form. I want the form to automatically close when a date is clicked, but the way it is now, my entire main form closes rather than the calendar. Here is a portion on my code for the calendar. Any...

I am trying to update an Access field for pricing for a quote log. Some of the records have the price quote and some have NQ for "No Quote" I would like to make the records that are a numeric value appear as currency and leave the "NQ"s as text. Is this possible?????

That's you. You got it! Thanks alot for the help. -Keith

Both the Employee and Employee_Name exist. I'm pretty sure the sql is good. I built it using the QBE Generator in access, so when I run the query it works. Then I copied the SQL statement from the QBE to my code. I also tried running the OpenRecordset() and using the name of the query instead of...

I'm trying to run a DAO recordset when a value gets updated on a form in MS Access 97. Dim rstTemp As DAO.Recordset strSQL = "SELECT [WORK ORDER HISTORY].[INCIDENT NO], [WORK ORDER HISTORY].machine, [WORK ORDER HISTORY].DESCRIPTION, [WORK ORDER HISTORY].dept, EMPLOYEES.EMPLOYEE, [WORK...

That worked perfect...Thanks a ton

Everything that I try just gives me an error on the next line...does the fact that the database has been converted from XP to 97 play a factor?. The thing won't eve work when I delete my switchboard and start from scratch

I am Still getting the type mismatch error where the code reads [code]Set rst = dbs.OpenRecordSet (strSQL). Does anyone know what causes this?

Thanks man, That worked...Now I have to fix the type mismatch error at Set rst = dbs.OpenRecordset(strSQL) and I should be good to go. Appreciate it.

Sure. it's all auto generated by the switchboard manager: Private Sub FillOptions() ' Fill in the options for this switchboard page. ' The number of buttons on the form. Const conNumButtons = 8 Dim dbs As Database Dim rst As Recordset Dim strSQL As String Dim...

I am trying to create a switchboard to navigate through 8 forms that I have already created. I used the switchboard manager as I always do, but on this particular project My switchboard will not run. I am getting an error code the reads "User-defined type not defined" in the code...

I am creating a form for a database at work and I would like to autopopulate the "date" field with the date and time that the record was saved. Is there any way to capture the now function? Thank you very much