Search results

Hi, I want to be able to hide the toolbars and ribbon for users accessing my db so that they can only use it as I intended, as an app. However when I click the Office Button in Access 2007 and go to Access Options > Current Database > Ribbon and Toolbar Options and I turn off 'Allow Full...

Yea I have tried this but when I copy a rectangle image over from word, it does not copy over smoothly. The corners are very pixelated & jageddy. Is there any property to set the corners on a rectangle in access?

I can create a normal rectangle, but how do I round the corners off? Is it a property of the object?

How do I create a rectangle with rounded corners on a form? Cheers

Thats sort of the thing yea, but that only allows a particular text box to expand depending on what is stored in it. I actually want a whole section of the form to appear and dissapear on the click of a check box.

Thanks very much for that mate, thats really helpful. Is there anyway to make a section of the form collapsible and expandable on the update of the checkbox? A bit like the example in the link below. I know this is AJAX but I wonder if there is a way to mimic this in access...

Hi, I have a form that has unbound text boxes on it. How can I hide a section of the form until the user checks a box? When the user checks a box I want the hidden text boxes to appear, much like a cascading web form. Cheers

That works, thats brilliant, thanks very much!

Yea thats exactly what I'm trying to do. So I'm guessing that a DLookup is not the way to do things, espcially as i seem to have got it completely wrong! I do need to store this 6mth_review date in a field for auditing purposes. Is there an update statement I can use to insert a date into...

Done that, still getting an 'Unknown' error.

Hi, I am trying to update a date field in a table with a sql dateadd based on another date field in the same table. I have it within a RunSQL statement. I cannot seem to get the SQL DATEADD function to workl within the RunSQL. This is what I have currently: DoCmd.RunSQL "UPDATE tblShields...

Im still getting a syntax error for some reason. Sorry to be a pain in the arse but its really frustrating me!

I have tried the SQL just in a query window: UPDATE tblUser SET sg_id = (SELECT SG_ID FROM tblSource_Group WHERE SG_name = [Forms].[frmAddNewPerson].[txtSG] AND RAO_ID = (SELECT RAO_ID...

Hi, I am trying to write to an ID number to a field using the following SQL: DoCmd.RunSQL "UPDATE tblUser SET sg_id = (SELECT SG_ID FROM tblSource_Group WHERE SG_name = txtSG AND...

Hi, I have a couple of combo boxes on an unbound form. One of the combo boxes just displays a list of everything in one field in a table. I then want the rows available to select in the second box to be filtered by what was selected in the first box. This is the row source I have for...

I have solved one issue, it was erroring on foreign keys, but I now have another problem! I am trying to populate the foreign key with a sub select in the insert statement: DoCmd.RunSQL "INSERT INTO tblUser ([System UserID], person_ID...

Thanks for that. I have removed the line to set warnings to false, but still no warnings are appearing when I run the code. It just seems to ignore the second 2 SQL statements. ???

Hi, I have the following statement to write the contents of text boxes on a form into 3 tables: Private Sub cmdSubmit_Click() DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tblPerson (forename, surname, organisation_org_ID, address_1, address_2, address_3, postcode, tel_tel, tel_mob...