Recent content by genghis82

I found the following worked fine Although I think that the following is a better setup as it eradicates the duplication of city names City Location ID City People ID LocationID BirthPlace Deathplace HTH:)

thanks for this suggestion Ken ;D made me rethink a lot of previous work i have done for similar suggestions which I have now replaced with the dlookup function. This is my first db so still learning! cheers again

nevermind I was being a muppet again ! I put the after update event to another of the controls as having it on the same control I was wanting to bypass, was asking for trouble. I shall hang my head in shame ;)

Hi Ken If you are referring to the global variable as Single: Option Compare Database Global g_Conversion As Single Option Explicit Hope this is the info your looking for ??:confused:

I have a global variable called g_dblConversion that saves the conversion rate from a seperate form for use in the order form. On the order form I have a list price box which pulls the list price from the table on which I have placed the following on before update: Me.TxtListPrice.Value =...

ahh a real problem all the time. The number of times I've pulled my hair out over this. I find that this is usually a result of pulling a control to far to the side. You can try to make the page more narrow and change the page/column widths as well. If anyone has any code that could resizes the...

Can you post the SQL of your query? Not too sure how your tables are set up. But if you have males in 1 column and females in another you should be able to create a new field in the query such as :Expr1: [Males]+[Females] HTH

if you save the front end on the server as well. then you can copy and paste it on to the required desktops. The linked tables in your front end should point to the tables in the backend so this shouldn't be a problem. Alternatively you can put a copy of the database on each terminal and then...

Hi Doc Thanks for this suggestion. I had never heard of this before so it was interesting to read up on. The only problem with the code I was trying to write was that it was on 5 mutually exclusive if statements. However I was trying to use this for the Sent Status as this could be written as a...

Hi Pat, Thanks a lot for this. Your right in that my logic on this was flawed. I've rewritten the code as you suggested and now have : Private Sub Form_Current() 'displays the study file status and the TA status for any study On Error GoTo PROC_ERR Dim SFStatus As String Dim TAStatus As...

Hi Not too sure I understand what your saying. I dont actually store these statuses anywhere as I only use it to output on to a label message. When someone searches for the Study Number they are then shown a message screen showing the full status which is dependent on a number of fields...

Hi I have code in vba that I want to execute only if a number of criteria are met. Private Sub Form_Current() 'displays the file status and the TA status for any study On Error GoTo PROC_ERR Dim SFStatus As String Dim SFStatus1 As String Dim SFStatus2 As String Dim SFStatus3 As String Dim...