Ask Your Question

IanP's profile - activity

2015-09-01 15:39:03 +0200 received badge  Famous Question (source)
2015-07-03 18:01:50 +0200 received badge  Notable Question (source)
2015-07-03 18:01:50 +0200 received badge  Popular Question (source)
2015-04-12 20:31:46 +0200 received badge  Famous Question (source)
2015-03-10 21:19:43 +0200 received badge  Notable Question (source)
2015-03-10 21:19:43 +0200 received badge  Famous Question (source)
2015-01-15 10:46:21 +0200 received badge  Famous Question (source)
2014-07-15 16:35:19 +0200 asked a question How can I sanitise a form entry before inserting the data into a database table?

I have a form which adds records to a table. It has some text fields. How do I make the form trim any leading and trailing whitespace from these text fields?

2014-07-02 17:45:32 +0200 received badge  Notable Question (source)
2014-06-25 22:19:22 +0200 received badge  Notable Question (source)
2014-06-24 15:00:39 +0200 received badge  Popular Question (source)
2014-06-24 05:23:47 +0200 received badge  Popular Question (source)
2014-06-24 02:49:10 +0200 received badge  Popular Question (source)
2014-06-23 21:50:21 +0200 asked a question Alter a Form's Data Entry Mode

Hi All,

I've created a form which has the Data Entry Mode set to Display All Data. If I make a copy of the form, I want to switch the Data Entry Mode to New Data Only. How do I do this? I saw a thread which said to right-click the form's background, and select Properties, but there is no Properties option in the right-click menu.

Thanks.

2014-06-23 21:43:22 +0200 answered a question How do I set creation and modification dates automatically in my table rows?

Hi,

Half way there, this does the Record Creation Date. How do I do the Record Update Date?

2014-06-23 17:44:54 +0200 answered a question How to change a data entry form to accept new records only?

I need to do this, too. However:

Right-mouse button click on an empty part of your form, and choose Properties.

There is no Properties. What next?

2014-06-23 17:24:49 +0200 asked a question How do I set creation and modification dates automatically in my table rows?

Hi All,

I've got a table with two date fields, Record Creation Date Record Update Date

How do I get them to auto-populate i.e. the Creation date should be populated only when the record is created, the Update date should be altered whenever the record is saved.

Thanks.

2014-06-23 14:04:03 +0200 asked a question How do I populate a table using a dropdown list which contains values from another table

Hi All,

I've got Table1. One of the fields is Table1.Status, it's an integer.

There are a finite number of different statusses. I've got Table2 which contains two fields, Table2.ID (integer, primary key) Table2.Status (text).

I've got a query which correctly links Table1.Status to Table2.ID

I've got a form with a listbox. It shows a list of Table2.Status. When I select one of the options, it correctly populates Table1.Status with the correct integer from Table2.ID.

However, if I use the form to go to an existing record, and try to select a differrent option, it refuses to save the modification, saying "Error updating the current record"

What am I doing wrong?