Search results

That's great, I was worried if I didn't import certain objects that it could cause problems. I tried the copy and paste but it was a bit annoying as I first had to select each object (over 300 objects) and then each time it tried to paste a linked table I got a popup message to copy as linked...

They are definitely system tables, they are not hidden as I use the UsysRibbons table to add ribbons etc... and then hide it. I haven't tried copying and pasting, but will try it. My main concern is the relationships though, if I don't import the system table MSysRelationships will that cause...

I have an access database that was set with security about 10 years ago. I have now created another database in 2010 and I am importing all the objects to make a clean non secured database. When I import tables it imports system table objects like MSysRelationships, but as it already exists it...

I have the following script which sets the currentuser, however it clears currentuser when I open the database and I don't want this, I want the currentuser to be there and it only changes when I want it to change. I.e. when the database opens if no value is found in my table then the name...

Thanks Dave, No, I haven't touched the mdw file at this stage. I was going to remove the admin password (which tried, then reset back) and then create new databases and import the objects from the old into the new as reading up on the mdw it seems that many people have had issues, whereas the...

I am using Access 2010 and I removed the Admin password and now when I open a database I get a message like you do not have necessary permission to us the X;\Jobs_2002_be.mdb' object How do I fix this, as when I log on to a different database I then get a message saying record(s) cannot be...

Sorry for the late reply, Thanks for your help everyone, I have gone with Jdraw's script as it is the first I tested and it does the job nicely.

Thanks Dave, sorry for calling you Gemma, I didn't read your signature until now, Usually I reply to people using their user name as that's the only name provided.

Hi VBAInet, As per my code in the original post, they are added through a code into a value list, can you please help with the code to sort the items as I thought that when looping through a folder it would put them in the correct sort order but it doesn't. Me.Listbox1.RowSource = "" Dim...

Thanks for responding but I don't think that you read this section properly. I have a load of queries that have currentuser in them (in various fields) and I don't want to have to go into every query and change the fields to reflect textboxes or dim statement's, I want to change the currentuser...

I know that people are going to want to attack me for this question, if that is you, then please just move on. I want to know if it's possible to change the currentuser temporarily using code. Why? Because I am moving away from the security and just having a logon database which copies a...

Hi Gemma, Are you able to provide the array script?

Compile error: Method or data member not found. Dim i As Long Dim j As Long Dim temp As Variant With Me.Listbox1 For j = 0 To Listbox1.ListCount - 2 For i = 0 To Listbox1.ListCount - 2 If .List(i) > .List(i + 1) Then...

I have the following code to fill a listbox with file names. I can not get it to sort it, I found a script but it errors on .list Fill the listbox Me.Listbox1.RowSource = "" Dim MyFolder As String Dim MyFile As String 'Dim j As Integer MyFolder = "C:\dbase" MyFile = Dir(MyFolder &...

Thanks for your help.

It seems to be because this textbox is bound to a field in the table. If I remove the controlsource it displays fine. I checked the field properties in the table and they are set to date/time but only show the date not time.

thanks, but the date time still shows as 00:00, yet on other forms I do not have this problem, so I am not sure what setting is throwing this specific textbox off.

I have a textbox set to a default value of =now() I have the textbox format set as dd/mm/yy hh:nn The problem I am having is that the date shows as hh:nn of 00:00, it isn't showing the actually time of say 08:51. The table field is set to date time. I have tried =date() and =Today() also and...

I found the solution on the following site. https://social.msdn.microsoft.com/Forums/office/en-US/18588dd2-1c82-4965-9477-c38c0ea0f246/how-can-i-display-a-rcd-count-on-a-continuous-input-form?forum=accessdev

I have tried to use the following to put a row number in a textbox, but I get the name error. =RowNum([Forms]![PickList]![FON]) I want to add a row number for conditional formatting purposes, I don't have unique values in the FON field or any other field so that's not an option. I know that I...