Hello,
I am trying to create a button which users can click to activate the synchronisation process within a replica set without having to use the MS Access menus or the Database window (as both of these will be disabled).
Any ideas would be much appreciated.
cheers,
Siwei
chengsi
Last Activity: Apr 13 '07, 07:08 AM
Joined: Oct 23 '06
Location:
-
Creating a button/macro to activate synchronisation
-
ChaseCox,
Appreciate your reply, however my issue is that the number of checkboxes are not fixed as they are determined by the number of entries in the table (which is dynamic). Also, the checkboxes do not have individual names as they are essentially one control (i.e. Aust_Ent_Sum) being used to represent the entire field in a continuous form.
I had been thinking maybe some sort of loop is required in VBA, but not... -
"Check all" button checkboxes in MS Access
Hi,
I have a "continuous " subform which is linked to a table which has a checkbox field. I would like to create a Check All/Uncheck All checkbox control that both checks and disables the checkboxes in the subform.
At the moment I can disable/enable all textboxes, however my coding only checks/unchecks the FIRST checkbox in the subform, and ignores the other checkboxes in the list. My current VBA code is:... -
Sorry, one other thing. Is there a way to prevent the "Are you sure you want to delete a table", and "Are you sure you want to add 3 records" etc. prompts from coming up when you run the Make-table query?
Many thanks....Leave a comment:
-
Yes I see. It worked. Thanks for your help!...Leave a comment:
-
Thanks PEB. Just wondering however, the database is for a client so it needs to by dynamic. Can this be done thru a Make-table query?...Leave a comment:
-
System Resource Exceeded error
Hi guys,
I get the "System Resource Exceeded" error when I run a report, but the query which it is based on runs ok (take about 1.5 mins to run tho).
Anyone have any suggestions on how to avoid this error/use less resource?
Much appreciated. -
Hi NeoPa,
If I was using your first suggestion (i.e. code in the TextBoxes of the Report as
[Code]=Format(Val([FieldName]),"#,##0.00") , where/how do i input this code?
Thanks....Leave a comment:
-
Formating fields in a report
Hi all,
I have used a cross-tab query combining some text and number fields to generate a report. Unfortunately, the cross-tab query results in all fields being classified as TEXT fields and I have no way of avoiding the cross-tab query.
Hence, does anyone know how to format a TEXT field such as '1234567' into '1,234,567' in a report?
Cheers. -
Converting text to display as currency in Report
I have based a report on a crosstab query. This query has eliminated all formats, i.e. all fields including those containing numbers are now stored as text.
Is there a way that i can get Access to reformat these 'text' fields as currency or standard 1,234,567 notation on the final report?
Thanks. -
Hi mmcarthy,
I've tried to do as suggested but could not get it to work. Could you go into that solution with a bit more detail, that is what i should be telling each control/form event to be doing?
Much appreciated.Leave a comment:
-
Thanks for offering that mmcarthy.
I tried it but it said that there is an error with syntax in the expression??Leave a comment:
-
Hi mmcarthy, thanks for offering to help. Pls see below the query i'm using to assign a ranking:
IntlRP_Rank_b: (SELECT COUNT(*) FROM [q_Trans_1c_sum_ by_country] AS IntlRPTotal_a WHERE
[q_Trans_1c_sum_ by_country].[Ind_Rank] = IntlRPTotal_a.I nd_Rank AND
[q_Trans_1c_sum_ by_country].[Trans_2a_Aust_E nt_Name] = IntlRPTotal_a.T rans_2a_Aust_En t_Name AND
[q_Trans_1c_sum_ by_country].[SumOfSumOfTrans _2a_AUD1] = IntlRPTotal_a.S umOfSumOfTrans_ 2a_AUD1...Leave a comment:
-
Progress indicator for Queries/Reports
Hi,
I have a report which is taking a rather long time to generate because i have had to use nested ranking queries (i'm not sure if nested is the right term - basically rank within rank queries). Unfortunately, this has meant it the report takes 2 minutes+ to generate.
Is there a way of making a progress indicator for the report so that users don't think their computer has crashed?
Thanks again. -
Enable/disable controls on a Tabulated Form
Hi all,
This is my first post, so please excuse if i am posting a silly question.
I have an MS Access database and have created a tabulated form (where there are multiple lines, one for each record - similar to a table, hence the name). There are about 10 fields or so, and i have used textboxes, combo-boxes and checkboxes to represent the fields.
What I am trying to do is to enable or disable textbox_2,...
No activity results to display
Leave a comment: