Search results

Hi A table with over 2000 records in is the main source table for our Controls Database, it has SalesOrders on etc etc. I am trying to import fresh data everynight into, and thought an Append Query would be the way forward. It does work to a degree, but how do I stop it from importing...

Hi all, I have a form with 3 Tabbed Forms within it. One of which is a Revisions form, which the user is directed too after every change to any of the other forms. This form has todays date, reason for change and the current user. As there can be many entries it is a continous form. When...

Hi Guys I have tried to create a link from an Excel Sheet to a table in an Access database. This all works fine, but if the database has that particular table open then the Excel User gets the following error message 'Excel cannot open file "Test.xlsx' because the file format or file...

Hi Everyone Just a quick note to say a big thanks to all for your input. I managed the get the form doing as I wanted, but the swines then changed their minds and decided to change what they wanted. Oh well, at least I've learnt something and can perhaps use it again at some point. Once...

There are about 30 textboxes on each form, the form is linked to a specific table On this form all textboxes start txtCSP1, txtCSP2 and so on, until txtCSP25. All textboxes will have a corresponding Control CSP1, CSP2 etc

I see now, but how can I get it to check the other 30 TextBoxes? Using If Len(Me.Text11 & vbNullString) = 0 'only checks the one textbox.

Sorry, thats already in, just omitted it. DOH! But the code is not checking the form. This form has 30 odd textboxes to check.

Hi I've just been introduced to the wonderful world of 'Tags' Using the following code on the 'On current' of the form, trying to get the code to check the textboxes, in the form that have the Tag name dAble I the textbox has a value then disable it, else leave it blank. But I think i am...

When a form closes, a loop that looks at all the textboxes, if they are still blank then they stay enabled else Disabled

If the user populates a textbox and closes the form, the next time the form is opened the textbox that has data is then locked or disabled, the textboxes that are still empty are available for data. Basically we are trying to stop users changing data after the initial entry I can manage to do...

Hi all Thought I'd done with this database, but alas, Users, don't we love 'em? A form that has 20 or so TextBoxes in, users can quite simply fill in the textboxes they want, but when the Form closes I need the textboxes with data in to become disabled? but the textboxes without any data to...

Yes ctl.disabled - I should've spotted that one DOH!! Many thanks Bob, Dave and VilaRestal it's now working like I want, and saving me so so much time. Many Many Thanks again Gareth

OK, a degree of success Private Sub Form_Current() Dim ctl As Control Dim rst As DAO.Recordset ' am assuming if they are in there then it should be disabled 'Set rst = "Select tblGroup where Group = " & Chr(34) & VBA.Environ("username") & Chr(34) If ControlsAdmin = "User" Then For Each...

Yes there is a Custom login system, a Public Variable knows which group the user is a member of, in this case either 'Administrator' or 'User'

I don't want to use the VBA.Environ I need to use the data in tblUsers I have amended to Set rst = CurrentDb.OpenRecordset("Select tblUsers where Group = " & ("User")) Getting Run-time error 3075 Syntax error (missing operator) in query expressions 'tblUsers where Group = User'

But in tblUsers, there is a field called 'Group', of which the options are either 'user' or 'administrator', so I figured the code was querying that. So if the user was in the 'User' field then the controls specified could be disabled. Thanks for responding. GW

Bob Thanks for the code example, it looks just the job and I can now use your procedure elsewhere in the database too, saving me loads of time. However, can't seem to get the code right on the 'Set rst' line below, keeps coming up Object required. I've tried various alternatives but alas...

Hi All Is there a quicker way to do the following A form has 20 Text Boxes on, all enabled. But if a certain user logs in I want to disable 10. The way I would currently program is something like, the On Current of the form to say something like If User = "John Smith" then txt1.enabled =...

Sorted it now, it needed code on the 'On Close' of the form. Thanks again

Thanks for replying I have now changed the Public Variable to ControlsAdmin, just to make sure AdminUser isn't elsewhere. I have simply placed the Public ControlsAdmin as String, onto the first form?? I take it that's not the Code Module??? So I have created a separate Module file and...