Search results

Travis: Thanks, but there are seven different activities I need to track, and the entries can't go into the same subtable unless there is some indicating field as to which activity the input date applies to. Plus, the client wants the new date to be calculated, not manually input. Thanks. Tom

I have one client that keeps coming up with 'enhancements' that I don't know how to do. I have done pretty well so far, but this one has me stumped. The service activity requires seven reminder dates for each client. He wants me to create seven reminder date fields to facilitate this. In...

glynch: I was just ready to give up and reset the months back to numbers, but I tried what you posted here and, with little difficulty, got what I was looking for. I cannot tell you how much I appreciate your help... especially seeing how it is 1:02am here and I am meeting them at 10:00...

Brad: Thanks for the help. Before coming back on, I figured out a procedure that works: Add the new field to main table, as you suggested. Simply copy/paste the appropriate range from the Excel spreadsheet onto the Tables tab of the database, creating a new table (be careful to name your...

Wow... I'm not sure I understand. I think I know WHAT you mean, since I have used tables for sources of lookup functions... but I don't know HOW to do it in this situation to get the desired result. I'm not sure I understand the term 'foreign key.' Thanks for the ideas so far. Tom

Ok.... I need another kick in the pants. My main table is called Personal Info. The key field is SSN. I have just added a field to the Personal Info table called Spouse. I have been given a table of information called Spouse Names that has the primary person's SSN related to the key field in...

I have been given a table with the fields Salary AutoNum, SSN, Month, Year, and Salary. The table tracks salaries by the month and is reported to my client in a spreadsheet. The Year is 4 digits (e.g. "2002") and and the Month is 3 characters (e.g. "Jan"). My client wants to keep this...

I'm not really convinced that your problem is VB related. I had a client with exactly the same problem. We did two things: 1) upgraded all their Access versions and the database to 2000, and 2) solicited the assistance of their Novell network support to make sure we reloaded the database to a...

Is the "Restrict to List" property set to Yes?

Brad: UPDATE QUERY! Thanks! I have never had the necessity to use one, had never really studied what they did and had never conceptualized why I would ever use one. After doing a little reading, this is obviously exactly what I need to do. Thanks for the kick in the pants. Tom

I have been given a new set of fields to add to a database table. The new information to be added is all in Excel. I know I can 'append' new records to a table... but how do you add a new field and get the information into the appropriate already-existing records? The database has client...

I can't believe I struggled with this after realizing that I already know how to do this!! Write a query from your two tables. Include in the query the field on the "1" side of the relationship that you want to autofill. Then include ALL the fields from the "many" table. Base your input form...

Pat: Thanks for the help... but is the query as I described the one I need? On my form, the field is there for display only. I have the number in the agent phone table for the query to access and fill the form field. In the form's phone field, is there code I would write to requery the info...

I have the same issue with a table of Agents and their Phone number, in trying to enter an Agent from a form combo box and have the Phone number pop in automatically. I have read many of the previous threads and I am just not getting it... Help is appreciated!!! Here are the pertinent fields...

Rich: Could you elaborate? I am open to any and all suggestions. Tom

Hello all. I have a list of records to import from Excel into my Access database. The records were dated as the first day of the month in which the record activity actually occured. E.G. 4/1/2000. In the import, I would like to format the date date as either "Apr, 2000" or separate fields...

OK... I would like to use VBA code, but I have little understanding. I found the DateSerial function, and put the following in an unbound text box: =DateSerial(Year([Birthdate])+65,Month([BirthDate])+1,1) It works. Tom

Pat: I am obviously missing something significant here. I do not have a query related to this. All I have is a form field called "Birthdate" and a form field in which I want to calculate the retirement date, which is to be called "Normal Retirement Date." The date should be the first of the...

I am still struggling with this. Thanks for any who can clear this up for me. Tom

OK... I am just not getting this. I have a field called "birthdate" and am trying to create one called "Normal Retirement Date" with the formula. I am not sure how to create the field using the code or how to name the field to be updated. I am still hung up, I think, on Excel formula syntax...