Search results

When you run a make table, you can create blank fields (to be updated later) by giving the field a name and then entering a null valur. For example: NewField:0 would create a numeric field with 0 as the value NewField:"" would create a blank text field Is it possible to create a field...

Thanks Thanks Pat, that di the trick!

I've got a database with clients and services. ServiceA1 ServiceA2 ServiceA3 ServiceB1 ServiceB2 ServiceB3 I am trying to write a Query to get all the clients who received a B group service, but excluding any clients who got both A and B services. I wrote it thusly (in criteria for service...

Preventing Database Corruption I have been having lots of problems with this. After research and trial and error I have several suggestions. 1. Run a compact and repair daily - I don't know anything about Novell Servers, but on a Windows Server I would install the database on the server. In...

Sorry - I was perusing old posts. Why shouldn't you place the system.mdw file on the server. For example, a network has 5 computers all running the database. The back end and the system.mdw file are on a server. Now, any user can access the database from any computer, using his or her own...

Does anyone know if there is a way to change the path to linked tables using the runtime version of Accesss 2000?

Crash how? Is Access freezing? If so, try this: - Search My Computer for the file Accwiz.dll - There may be several, so look for the most recent version (Right click, go to properties, pick the one with the highest version number) and note the path of where this .dll sits on My Computer - Go...

I am receiving this error only on some computers. I have a database that I know works. I have it installed on many computers. But for some reason, on one specific network, when I try to install the database I get this error. Even more infuriatingly, if I install as the administrator it works...

No Dice I tried the "me.[start_date]" thing and no dice. The query that the dates affect is this: SELECT srv_patient.ptn_pk, srv_client_questionaire.cln_qs_annual_year, srv_patient.ptn_custom_4_rfk, Max(srv_saar_service.sar_sr_date) AS MaxOfsar_sr_date...

I am building a database that is geared towards running a report with some totals of the information in a seperate database. I have created all my queries. They all work. I have created my report. It works. Now I am making a form where the user enters dates to limit the data included in the...

I have a database and security is established using a workgroup... no problem. I have a Set Up form in the database that I want to have extra security, not because the user shouldn't be able to change the form, but there are consequences if they do, so I want the database to re-ask for the...

Hmmm... What I want is for the user to set these dates at the beginning of the school year, and then those dates should be obtainable from anywhere in the database for query's and reports and such. AND, their should be some way to prevent them from getting changed accidentally. The reason I...

I am creating a database that will schedule events over the course of three weekends, and I need to reset those weekends each school year. I have created a form for entering those dates, and I think I want to store them in a module as global functions. I set up those global functions, but I am...

It Works! Pat - Thanks for your suggestion, it worked. Yes, it would be a problem if I had more than 99, but this could be solved by using Format(YouFieldB, "000") or more zeros, anyway. Thanks for the tip.

OK, so I have to combine two tables with the same information (customers), but the primary keys are totally different. So, I combine the tables, and then I am trying to generate a new set of primary keys. The PK is 03054446100000 then two digits starting with 01 and then consective: Example...

Append Query Append one table onto another.

I am having a problem that has been addressed here before, but I am looking for a more elegent solution. I have a Query that generates a list of dated events. I want to limit that list to events falling between certain dates, NOT USING THE [ENTER START DATE] method. I have a nice form where the...