Search results

I have a table with one primary key (ClientID) which is an autonumber (cannot be duplicated), and another field which is a number field which is set to a random 6 digits (also cannot be duplicated) whenever a new client record is created. Now, the main database is on a desktop, and my partner...

Thanks, yes we have thought of that but we want to keep the Control ID separate from the Client ID...and also want to make the Client ID a random number, so the numbers don't go up sequentially

I have a Client Table which has the following Primary Key: "Control ID". The Control ID is an autonumber (ID increases by 1 with each new client). Now, I also need to create another field called "Client ID". The Client ID is unique for each client, but needs to be a random number, in the...

Hi, I have a form and want to change the background color and the record scroll/navigation button colors. Changing the background color is easy; just go into Design View, right click, and change the "background color" properties. Changing the record select button (on the bottom of the form)...

Thanks, I've created two append queries. My append query for the Client table works. When I run it, only the new records are added to the central database Client Table. For the second table, the Contact-Date Depandant table, only the first new record of each client gets added. If a client...

Thanks Tom and the rest of u guys, have been extremely helpful. I've been progressing well with this. 2 obstacles I'm having right now and haven't been able to figure out: 1. I still am not able to create one append query which updates "multiple" tables in my "main database". In the...

Thanks, I may look into this in the future. I just need a simple solution to centralizing my database when i add client records from my laptop out of the office. Still having problems =(

I know this thread was from awhile back, but I finally had the need to really set this centralizing up and I followed TKnight's instructions above using an append query. It has worked well however I have 2 problems: 1) After running the append query in my off-site database, the table on the...

^^ Thanks Pat, I will add that option. I'm still stuck though with my original problem. Can't seem to get the SQL right, and not sure where to put the it.

^^ I'm not sure what you mean. Right now I have the BankName AND BankNumber as separate fields in one table. For the BankName field I have the display control set to "Combo Box", the Row Source Type as "Value List", and in the Row Source, I've manually entered different bank names for the...

I have a simple table with two fields in that table called: 1. BankName 2. BankNumber Each bank has a bank number. For example Bank XYZ and all of its branches have the same Bank Number 123. There are 5 banks I have listed in a combo list under the BankName field. I can also type in a...

I tried grouping the field year together in the report, but what the report will do is create an additional page for the same client if there are multiple years (with the same header on the 2nd page). I want the multiple years to show up on the same page of the report if multiple years exist...

When I run the query, it does list out multiple records for clients with multiple years. ... but I'm my report I'm not sure how to show the multiple years for clients with multiple years... what i basically did with the report is drag and drop the "year" from the query's field list into the...

One reason is b/c some "clients" may have free service and not require an invoice. Thanks, hope this helps.

I have created a report for an underlying table. The underlying table records clients and their income for a certain year or years (in multiple records for client with multiple years). For example, client 1 may show income of $20000 for 2005, and in their second record 2004, income of $10000...

I am trying to incorporate a field in my customer order form for "Invoice Number". Not every customer order form will have an invoice number. The Invoice Number field will default as null, or blank. I want to make it so the Invoice Number gets automatically populated ONLY IF another field...

:) Thanks Pat.

I have a Form which shows a bunch of client personal info, and 1. fees a client pays, and 2. a calculated value which shows the sum of fees + taxes. I've created a report which also shows the fees for every client, to be an invoice report. Now, on the original Form, I want to be able to...

Thanks a lot Treason, that worked. When "Online" is selected, the other fields get blanked out except the "OnlineMethod" field, which is great. I've replicated the code for the other fields, ie. if "Flyer" is selected, the fields "OnlineMethod" and "ReferralName" get blanked out and...

Thanks...but not working. I put this code into the After_Update in the properties of the HowHeardAboutUs field: If Me.HowHeardAboutUs.Column(0) = "Online" then Me.FriendName.Enabled = False Me.FlyerLocation.Enabled = False Else Me.FriendName.Enabled = True Me.FlyerLocation.Enabled = True End...