Search results

Hello, I'm using the Custom Demo Counter example from MSDN (http://support.microsoft.com/kb/140908 )and i want to change it in order to keep 12 counters (one for each month). I added 12 rows in the CounterTable each one starting from zero. How can i refer to each one? For example how can i...

Thanks that's more suitable for me because it's not necessary to save the value :) I never posted twice the same post and when i posted the second post you hadn't answer yet (i saw your answer today). If you take a look to my previous posts you will see that i am always trying to respect the...

that works thank you! is it possible to use the module to a report or do i have to store the strAddressBlock into a table field and then use it to the report?

How to build an expression in a query with multiple lines. Hello, I'm trying to build a string as expression into a query. What i want to do is to get the field [Address],[PostalCode],[Village],[District] from table tblApplicant and build an address block as the following but i don't know...

Hello, I'm trying to build a string as expression into a query. What i want to do is to get the field [Address],[PostalCode],[Village],[District] from table tblApplicant and build an address block as the following but i don't know which character to use for changing line Address Block...

that works! thank you for the help! :)

Hello, I have a combobox that uses a query as a row source. The query has 3 columns (ID, Description, Code). In the combobox at the form i only show the Description and when user choose I save the ID to a table. The problem is that i want to use the Code field as well (without appearing on the...

Hello, I need help with something (i attached a database). I need to run a report based on user's options so i created a form. There are two comboboxes and 2 checkboxes on the form. If the checkbox is checked i want to consider the choice of the user on the particular combobox. If no, to...

Hello, I need to control form's checkboxs by using the enter key instead of the mouse's click. Is there a property i can change to do that? Thank you in advance!

forgetting AND was the error! Thank you both for your help. :)

Hello, I want to link two forms based on two parameters NameID and Year. I tried the following but i get the error message "Invalid use of null" stLinkCriteria = "[NameID]=" & Me![Name] & Year(Me.ApplicationDate) = Me![Year] Can someone help me with this code line? Thank you in advance.

I found the error thanks! :)

I followed the steps of creating an Audit Log based on Allen Browne's solution (http://allenbrowne.com/AppAudit.html) When i try to update the record i get the following error message: "Run-time error 3063: Duplicate output destination 'audType'. Any suggestions how to solve the problem...

i hope everything goes ok Thank you all for your help:)

I must have the same database in different cities and the offices can't be live connected to the main server so i thought replication was a good idea in order to update the databases. I'm just worried about replication making access database more vulnerable, specially when each database has...

I created replication through Access, but when one of the users try to update a record he was getting the message Record deleted. So i search the internet and found that the solution of this error message was to Compact and Repair the database. When i did that i lost the replication, and now i...

I'm not sure if i am allowed to install MSDE to the computer so i will try the replication through access (master and replica). Thank you:)

Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them? Thank you in advance.

I'm trying to build an application that will allow the users to use databases that are not connected (because of location of some users they can't be online with main database). Until now the keys where autonumbers generated by access but that was a problem when i tried to merge the databases...

That works! Thank you :)