Recent content by jennypretty

Hello, I successfully created imported database tables into MS Access database that import all tables from SQL Server database. I don't do the linked tables because I want to have a way to modify data from these imported tables that will not affect the SQL tables. I am looking for a tool or a...

Yes. I picked the first option which is imported, that's why. I reset it up and picked the 2nd option and it worked fine. thanks.

I created MS Access linked tables to sql server already. I got all tables I need into MS Access database from SQL Server. However, it is like a copy so all updates on SQL Server database tables will not update on MS Access database tables. How do I make the automatic updates on MS Access...

Hello, I need ONLY online Q5 for lable, and the rest of don't have to show lable for one row. It will repeat the same for 2nd row. Like the one attached. I have this to eliminate the empty rows: strRowVal = "" If Len(Trim(Nz(Me.Q51.Value, ""))) > 0 Then strRowVal = strRowVal & Q51 & "*" End If...

I have a db. But the report format is not the format I want. Can you modify this format to be column-like format? like the attached file. Q5 (label) will line in one column. Data will line in the 2nd column. Any empty row will be removed on repot. Can it be this way? Thanks.

Here is my file. In general, there is q5a, q5b, q5c, q5d, q5e, I want to display them in one column on report, instead of 5 different columns, and skip any empty row instead of showing empty space on that ONE column. thanks.

The data come from the table. I can't use wizard to create report so I have to write a code Because wizard can't combine a few columns into one column (vertically). Thanks.

Hello, I am trying to create a report to set all Labels on one column (left) and data to 2nd column, but it does not work. My code below will combine a few table columns on one column and delete any empty rows. Can any one help please? Thanks. Dim nBaseXAxis As String 'var to keep left...

Lazy, can you help? thanks.

Sorry to bother you. I'll wait for you tomorrow then. In Oracle and SQL Server, we can combine a few rows to be columns-like, but in Access, is there any way to do that? thanks again. Jenny.

Hi Bob, ID Name Race1 Race2 Race3 -- ---- ----- ----- ----- 1 a Asian russian How do I create a query to be like this (either in query or report)? I like to combine three fields (race1, race2, race3) in one field (Race), and break any value of races to...

Thanks. I think I should go for one big table and use report and query to manipulate the data. thanks.

What is the main table? If I use ASP script to insert data to the main table, then the sub-tables will be inserted automatically, am I right? In other words, if I insert data to the main table, then all sub- related tables will be inserted automactically? thanks

Hello, I have a long table and don't know which way is the best way to break it down to small tables and join them together. Each student name can have more than 1 Race ID Name Race1 Race2 Race3 -- ---- ----- ----- ----- 1 a 2 2 b 3 1 3 c 1...

Thanks. I think i should create separate tables and join them together.