Search results for query: *

I am running Access 2000. The problem form is for tracking Hours. I have a main form that hold employees names and a continuous subform is fed off of those names. The subform holds the date and hours and operation, so one day could have multiple entries. I have some a Text box on the bottom...

I am using Access 2000. I have a crosstab query built on jobid as row, summary actual hours as value and operationID as column. I would like to have essentially the same thing in the same query, but limit the acutal hours dates. It won't let me have more than one value per crosstab query. Do...

Thanks all who read and answer my and everyone elses questions. I am not quite sure how to go about this. I have a main table: tblJobs and JobID relates to many records in tblRemainingHours. I want to get the most recent remaining hours date (RmgDate) record in my query. I have tried using...

Hello and thank you for looking at my problem. I get an error stating that "number of query values and detinations are not the same. Can anyone tell me what is wrong with the following code in Access 2000 written in VBA: Dim stSQL As String DoCmd.SetWarnings False stSQL = "INSERT...

I am not exactly sure how to go about this problem in Access 2000. I have a form built on employee records, and a subform with hours, operation etc. The operations are in a combobox fed from another table. I was wondering how I limit the operations combobox depending on the employee? Ie. Joe...

Well I hope someone else has had this issue, though I really wish it on no one. I am using Access 2000 and have built a pretty sizable DB that is split, with four different FEs on personal networked boxes and the BE on the Server. This has worked beautifully for quite some time as I have made...

Hello, I was wondering if someone might help with the following problem in Access 2000: I have an employee timesheet form containing a continuous subform containing the employee hours, date of hours etc. for the most recent 30 days. In the footer I have a correctly working sum for the most...

I imagine this might be something common, so just point me to a previous post, I couldn't find it. Problem is that my query is sorted by Ascending date which works perfectly in the datasheet view. Although when I use it in my continuous subform, it doesn't sort correctly. Any ideas? Thanks...

I have a continuous subform in Access 2000. I would like to open to always go to the last record in the continuous subform, unless I'm adding a new record. I put in the onCurrent event. Goto last record, but it won't let me out to go to a new record. I thought I could use onActivate, but I'm...

I have a tblJobs whose ID is JobID, then I have a tblRemainingHours that is in a many relationship to the tblJobs. Every week I will be entering new data into the tblRemainingHours. I want to sort tblJobs for CurrentJobs=True and for each of these jobs I need to the the latest date and...

I have two table which are linked via JOBID, then I have a query that pull different fields from the two tables. The results of the query when edited gives me an error stating "Recordset not Updateable". Both tables are autonumbered, they are linked via "indeterminate", but...

Access 2000 I have a form that sources a subform for employees hours etc. I would like to total the most recent days hours in the subform in an unbound field. I am having trouble figuring out how to use the current recordset of the subform for this. dim db as database ,rst as recordset...

I have split my database and it is working beautifully, but I come to the conclusion that I need another table. I added it in the front-end section (which is replicated). Somehow I don't think this is probably how I should do it, but I'm not in the mood for experimentation with our working DB...

I am using Access 2000. I split my database and have the tables on the server, and frontend replicas on my users boxes. I have the design master on my box. On Options, I have checked "open database using record level locking" and Default Record Locking to, "Edited Record&quot...

Hello, I am having trouble automating MS Project 2000 with MS Access 2000. I have had no trouble whatsoever with automating Excel. Here is the Code I'm using: Dim prjApp As MSProject.Application Dim prjProject As MSProject.Project prjApp.Visible = True Set prjApp =...

I have created an Access 2000 database which I would like to have push information into a MS Project file then link that file to my Access hours table. My problem is that I have no code that I can look over to try to decipher how I can do this. So does anyone have any code which uses Access...

I wondered if anyone knows how to either use a combo box or a button from a form to activate the "browse" feature to search for a file that once selected will be a hyperlink? I don't even know how to start. Though I am pretty familiar with VBA. Thanks Niko

Last night I was in the depths of programming access, this morning I wake up to find that when I double click on the file that usually opens my database, Access opens, but not my file! I have backup, but from a week ago...there has been a lot of changes since. The only unusual things that...

I am using Access 2000. I believe that I have the right code for the "Insert into and where" Portion: DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO [tblJobs](

I am looking for a way to create have a database or ? of different Word files that will count the characters per file. Can this be done in Visual Basic? Nishan Karassik