Search results

Hi All Hoping someone can help. I would like to create a stored procedure in SQL server which I can call from an access front-end application to determine what the role of the logged in user is to allow me to enable / disable application controls based on roles. I have the following code...

Hi All I have the following SQL string: strSql = "INSERT INTO t_ClientDemographics(client_FirstHCTVisitDate, client_ClientCode, client_FirstName, " & _ "client_LastName, fk_EmploymentStatusID, client_ClientEmployee, client_JobTitle, " & _...

Hello SamFischer I assume when you say link, that you are trying to build a relationship between the two tables. I notice that you say you have linked code, description and quantity. Are you using all three of these fields as a link? For me code would be the only identifier which should be...

Hi All Attached is a quick application which shows a method I use to create an audit trail of changes made to my forms. Just run the form, make changes to the various fields and the changes are recorded in the audit trail table. Comments and suggestions on how to further improve on this would...

Hi All I would just like to find out how long it takes before a sample submitted to the samples forum is approved. I submitted a database about 2 days ago and I see that nothing has shown up on the forum. Regards

Hi PTracer The way I would normally do this is on the repair form have a drop down list of customers and then select the customer and add the list of repairs. Another way you could do this is to store the customer id and computer id in variables which can be accessed by all the forms and use...

Do you want to be able to type a value in a field and then have the data displayed in the fields based on your search criteria?

My only suggestion at this time would be to ensure that the person being affected has exactly the same service packs, updates etc running as the other users. I have had users who have had similar problems and ensuring uniformity between all pc's has helped me.

Hi Nigel This error message usually occurs in the following instances ( someone correct me if i'm wrong ): 1. You are trying to assign a value to a control which does not accept values. 2. You are trying to assign a value to a control which is out of the acceptable range specified. So for...

Hi There Could you post your DB so that I can get a clearer understanding of what you are trying to achieve. I assume that what you want is you want to enter the amount that you are paying, which then automatically gets deducted from the amount due. You then want to new amount due displayed in...

Hi Yes, unbound forms are the way to go to achieve this. I use unbound forms which I feel gives me greater control of how to control and manipulate the data. I then use SQL statements which are run when the user clicks the buttons. If needed, I could whip up a quick example which shows you...

Hi All I created an audit trail which works completely different to all suggestions in this post which I thought I would share with you. The forms I create are not linked directly to a recordset, so any adding, editing etc takes place through code which is triggered for instance when the user...

Hey I use an access system in an multi user environment and generally find that corruption takes place when users do not disconnect from the system correctly. i.e not closing the database properly. Another thing I have experienced is that when problems on our network occur, such as users being...

Hi All I am wanting to use a barcode scanner to input data into a field and bring up details based on the barcode. This is simple enough as long as the field you want to scan into has focus. Is there a method which will automatically populate the correct field with the scanned data no matter...

Try If Not IsNull(Calendar1.Value) then If Calendar1.Value >= (MDate1 - 7) Then MsgBox "Cancellation must be at least seven days in advance of the first meeting.", vbOKOnly, "Cancellation Date" Else CDate1.Value = Calendar1.Value CDate1.SetFocus...

Try using COUNTRY = COUNTRY.ItemData(0)

Hi Chanel Not really quite sure what you are asking here, but I assume you have some controls on top for instance textboxes that you enter data into. You have textboxes at the bottom which you want to populate with exactly the same data from the top? If this is the case, then just set the value...

Private Function ReturnValue(ByVal yesInt As Integer) As String ReturnValue = IIf(yesInt = -1, "Yes", "No") End Function Private Sub Check0_Click() Dim myanswer As String myanswer = ReturnValue(CInt(Check0.Value)) MsgBox myanswer End Sub This should work just...

Could you post a picture and explain, maybe that would help. Attached is a picture of a form that I did for a project. One of many forms which is now being used in a clinical system.

Hi All you need to do is create a private sub as follows: ( i create a calendar control named Calendar0 and a text box control named Text1 ) Public Sub Calendar0_Click() Text1.Value = Calendar0.Value End Sub Hope this helps