Search results

Hi All I'm wanting to upsize my database to a SQL server - still using Access as the front end. Do I need to convert ALL events (and code in my modules) to Stored Procedures on the SQL server? How would I refer to fields/values on forms (or other queries) I also get the impression that I...

Is you database called 'Access.mdb' or something else? Also - I guess that word is asking you which TABLE/QUERY that it musty use to source the data. Are you specifying the Table/Query?

When a student moves onto (or Off) the campus, then we do two things. 1. Update their attendance code (ID_Att_Code) in the Student table 2. We also record a MOVEMENT record in the Stu_Movement table Therefore I am trying to automate the process so that when the user changes the ID_Att_Code...

Thanks Doc_Man It seems that I just needed to close and re-open the db to refresh it. It was doing strange things all around. Good point - I hadn't thought about this. there are no apostrophe's or double ampersands, all end in a double equals sign. I will strip that out of the checksum at...

Hi Galaxiom Normally, I would agree with you. However, the school that I am working for is 100% reliant on govt funding. Recently, we were asked to provide a physical address that is broken down to the following parts. (This is a part of my table structure...) CREATE TABLE [dbo].[CMTY_Address](...

Have you set the format on the field in designer view. I often find that even though the field is set to numeric, I still have to set the format to something. IE General Number or Fixed or Scientific etc.

Hi There When a user adds a new record (or edits an existing one) I generate a checksum value (based upon a number of fields) and use it in the 'Before Update' event to check that a duplicate record is not being created. If the Checksum already exists, then I want to undo the addition/update...

You cannot have two buttons that have the same name. Call them 'BuddyControl1" and "BuddyControl2" - or something like that.

I got a number solution https://en.wikibooks.org/wiki/Visual_Basic_for_Applications/String_Hashing_in_VBA

YES !!!!!! It turns out that instead of trying to save the record, I must UNDO it and then refresh.

I did reply earlier, but dont know what happend to my post. I would create a report and display that instead. (You could add pictures too)

OK - So I thought it was simply a case of me being dumb! I am inside a dirty record, so the refresh wont work till I save the record, so I tried replacing the 'me.requery' with the following .....none of which seem to work. DoCmd.RunCommand acCmdSaveRecord DoCmd.Save acForm...

You can set the default in the TABLE. When you add a record to the table, it will apply the value automatically. ONLY If you want to change the value from the default, then your query must say so. If your query does not specify a value for the default fields (but the table has this info) then...

Hi All I have a student enrolment form where I link students to parents. Because there are situations where 2 (or more students) can be enrolled AND there could be more than one parent, I need to establish a relationship between each student and each parent. I am therefore checking the...

I may be a bit late to the party here, but why not output the message to a report so that the user can print it our if they wish? You could add photos as well if required.

As far as I am aware, Sharepoint is SQL Server - so FAR more robust than Access database. Recently, I've been looking at doing this too. Am interested to know if you run into problems.

It seems that you are not talking to the objects (fields) on the form. So, if you field is called 'Score', then you need to say me.score = 200 or me.score = -200 However - if this is a running total, then you would say me.score = me.score + 200 or me.score = me.score - 200 Hope that gets you...

Hi All In order to ensure that I have clean(er) data in my address table, I am trying to ensure that the same address is not captured twice. (Impossible, I know, but I HAVE to try - 17 different spellings for the same town is getting ridiculous!) For this, I have tried to normalise just about...

Thanks Sean With a little tweaking that has done the trick.

Thanks Beetle and Sneeuberg Unfortunately, I need to display the parent as a split form. So the problem occurs if they select another record from the split form.