Recent content by pokerace

Got it. Thanks.

I have a basic report listing names, which are pulled from one table named Client. I would like to add data to this report that includes data found in other tables. For example, a table named Demographics and a field named Gender. In Crystal Reports I can do this by linking the two tables...

I have created a report that shows the Client.Name and the Client.Status. I want the report to show only names who have one of the following selected for their status: FirstYear, SecondYear, or Orientation. Do I need to enter vb code to make this happen? Where on the form do I enter it?

I would like for a form to show the last time it was updated so that users know that they have the most recent frontend file. I could just add in a label field and then change the date every time something with the form changes. Is there a better way, however? Should I input an auto date upon...

I am going to split a database, but at times the front end forms will need updated. I am going to create a batch file that the user can run, which will copy the updated frontend from a shared networked to replace their local copy. Is that an acceptable method or should I do something different?

I thought that I had an issue with Access over a WAN based on it's limitations, but it seems as if I had some flaws in the main form. However, part of my reason is just to learn how to do it, that is place a database backend in SQL Server and access it via an online form.

I have a form that automatically inserts a user's login name this command: =fOSUserName() Is this code pulling the user's name from the PC or the domain server? Can I also insert a users first and last name and if so, what is the code?

I've tried out your sample database and it has worked wonders! Now I am trying to understand it. Going through the code comments for the subform loading button, it seems that the subform must be added under the corresponding tab control, and then deleted, which will keep the links neccessary. Is...

Got it. Had the wrong form name in the code. DoCmd.OpenReport stDocName, acPreview, , "[Client ID]= forms![Form Client Information]![Client ID]"

I have a report named CaseNotes. I have inserted a command button on a form linking to the report, and I would like the report to be run for only the current record, by using the Client.Client ID field. How can I accomplish this? I have tried the following code in both the OnClick and OnEnter...

I have a form with a client name in the header. If printing the forms records exceeds one page, then I would like the header to print out on each page instead of just the first. Can I edit the form to allow that to happen?

I have an Access database and I would like to take a stab at putting the database online, i.e. converting the forms to a webpage interface (ASP? ADO?) and allowing users to access and update the data on the server. What direction should I take to accomplish this? Can I use SQL Server Express to...

Thanks for taking a look at the database bob and giving me something to try. Thanks as well to you Shadow for the tip about terminal server. I am going to explore both suggested options.

Ok, I tried to split the database and it is still too slow. I have compacted and zipped a backup of the unsplit db with sensitive data removed. It is password protected. I will send it to you bob and anyone who wants to take a crack at what my design issues could be.

Which means that I need to split the database? I can do that and I can look into removing sensitive data and uploading. Though, it isn't a large database at all; Only 13 tables and about 250 client records. As I understand the article though, my main issue right now is accessing the Access 2000...