Recent content by csk003

Thanks PHV. I am glad the query now prompts that it only updates how many ever rows that had * now instead of all the rows that the table has (it was giving this message earlier which got me confused)

Thak you Paul. I was thinking it would replace all characters if use "*" as it is wildcard but as we are using in " should be fine.

Thanks PHV. I am trying to replace this * with null and I am using this query update test1 set column1 = replace(column1,'**' ,"",1) Nothing gets replaced. Any ideas?

How can I search for character * through a query in a column's data?

I would like to view an include file in Front Page design view. How can I do it? I can see it in html format. If I can view the file in design view, would it be easy to change the navigation file buttons through moving in design view than changing the code.

Thank you, must have been using value or VB before

I created a form in Access 2003 added a command button and text box In the click event o f command button Textbox1.text= "testing" I get a runtime error 2185 you can't reference a propoerty or method of control unless the control has the focus I added textbox1.setfocus in the click button. It...

I have a table with City as column name and when I group by city I cannot distinguish between Dallas and DALLAS. They both are counted under Dallas. Even when I try to update Dallas to DALLAS all rows try to get updated instead of the ones with the exact case. Is there any way to identify them...

Thank you for helping me out. I used something similar in the meanwhile but didn't group by total or SELECT Count(*) FROM yourTable This is working but I am not sure if I am doing it correctly. Do I need to group by total too?

I can create a new table with counts and do this but I was wondering if access had a way to calculate counts and percentages in same query Original table has two fields id & type

I have a table with column named type. I can group and get the counts. Can I get percentages also in the same query? E.g. Percentage of type A = (50/400)*100 Type Count A 50 B 200 C 150

Thanks, Put the requery code in the change sections and it worked.

The main form(datasource: table1) and sub form are linked through an id. The values in subform(datasource:table2) for the column- subcolumn2 should be based on main form column2(value selected by user) and a table5. (Table5 has valid values of column2 and subcolumn2. I should be able to see the...

What would be the easy way to web enable an access database for entering data and querying? Users outside of our organization also need to access this database. Can data aceess pages read data from multiple tables and can we use sub forms or something similar to that?

Other users ahould not have access to designing queries and editing forms, they should be able to data enter tehrough forms already designed and query based on queries already designed. In that case would splitting actually help? or changing the tools->options to shared mode is fine. Can the...