Search results

Great stuff, thanks. Wouldn't you know it - for a completely unrelated reason, I've had to remove the defaults! This is because I have a multitenant server with remote logins from different timezones, so a default (getdate()) inserts the server time, not the user time. I'm hoping a change to the...

thanks Minty. smalldatetime is not working with the default (getdate()) either :-( I've now attempted to use smalldatetime, datetime, and datetime2(7) with the default (getdate()), and they all fail to allow updates on random records (roughly half of the records in the table) in Access. If I...

Ok, this works: CREATE TABLE [dbo].[tblDropOffClients2]( [ID] [int] IDENTITY(1,1) NOT NULL, [SessionID] [int] NOT NULL, [ClientID] [int] NOT NULL, [DropLocation] [nvarchar](255) NULL, [DropTime] [datetime2](0) NOT NULL, CONSTRAINT [PK_tblDropOffClients2] PRIMARY KEY...

Actually, I'm finding this problem extraordinary - all my CreatedOn fields in tables are now suspect. eww.

No, it doesn't prompt. I would not have expected it if there is a PK defined in SQL. In all my years, only tables with no defined PK will show the URI prompt.

Thanks Arnelgp, but I'm sorry to say that it makes no difference. This is what I did: I dropped the table and recreated in SSMS with NOT NULL for Drop time. I deleted and relinked the table in Access. I checked the indexes for the linked table to be sure it had a URI. And indeed there is a PK...

Hi, If I create a table in SQL Server Express as below with a default getdate(), and link it in Access, I can add new records via Access, but not update any - instead I get the 'this record has been changed by another user ...'. Changing the default to CURRENT_TIMESTAMP in SQL doesn't work...

Just love arrays for this sort of thing ... Function ExportTeamsToExcelForMerge() Dim dbs As DAO.Database, strSQL As String Dim xlApp As Object, xlWB As Object, xlWS As Object Dim n As Long, i As Long, nCol As Long Dim arrTeams On Error GoTo Catch_Error Set dbs =...

Ok, so let's assume you are wedded to the report design, and, I admit, with all it's programming shortcomings, it does look nice. Maybe the client insists. All the other suggestions above are important, but as a last resort, if you've got no options design-wise, why not put it on rails? That...

Thanks, of course! Terry Kreft's code, it all comes flooding back... Jack

Hi, I want to give my users a browse button to pick a folder, but the builtin file and folder pickers are too powerful - the user can, accidentally or deliberately, drag and drop folders, rename and delete from within the dialog. It doesn't seem that there is a way to prevent this - will I have...

This is where I find the users of the system start to show some brittleness. If you were to ask them what they wanted to see where different codes are used for sessions within the one date, I suspect there would be disagreement. If you have one main user, that simplifies things. They can guide...

You ask for "number of absences in AM and PM". In your registry table, you have 'Present at AM registration' and 'Present at PM registration', which makes it easy to work out AM or PM registration. But there is no AM/PM equivalent for late or absent. Late is just "Late but arrived before the...

Checked some old emails, it was May27, 2010

I don't recall, it would have been 2009 or 2010 I think.

Interesting isn't it, now I reflect. I kicked off my career at home here in Oz in 1992, and sold a couple of Access apps (installed with 9 floppy disks!) and clicked around the Access Ring looking for hints and tips while setting up my own gig. My first regular posts as a newbie were on...

done

Interestingly, I see an example in this very thread: Uncle Gizmo has 13k posts, and has a link to his (not free) apps in his sig. Great stuff, seems fine to me.

Thanks Jon, but I'm not saying I want to advertise. Folk are posting now and again on the issue of Access hosting, and I've seen other posts where people say "Try greatcompany.com, they do what you want. Spoiler alert, I work for them!" Or "A widgetname app will do that - I have one which you...

C'est cool. I'm hoping he takes a look at this thread.