Search results

After lots of googling, I found an answer that says that if (and only if) you are using an access BE as well as FE, you can get the ID of a newly created record by filling a variable before .update. So I tried this code: .AddNew...

One of my users keeps getting an error: Unrecognised database format: "H:\Database\MembershipDatabaseBackEnd.accdb" Most of the time all works as it should, but when this happens she has to close the front end and re-open. Is this likely to be a db problem or a network problem? Thanks, George

This code did it: If Not IsNull(txtSearch) Then txtSearch.SelStart = 0 txtSearch.SelLength = Len(txtSearch.Text) End If However, it has to go in the "On click" event, not the "Got Focus" event, which took some finding.

I don't know the technical terms for what I'm asking for here, which is impeding my success on google. One of the main forms on my db is a search form with a listbox, which is filtered by typing text into a text box. Users can then double-click on a record in the list box to open their details...

I've changed tack and solved the problem a different way, by applying filters, but I'd still like to know if/how you can use inconsistent update dynasets via VBA and SQL?

Hmm. I've worked out that I have the query saved as "Dynaset - inconsistent updates" and I'm not sure whether or how you can specify that in VBA

Hi. Thanks for the reply. Yes, I can edit the query in query view. If I save the query as recordsource in the subform, I can edit the sub-form. But when I use VBA to change the RecordSource to the SQL statement it is non-updateable. The main form is unbound and the sub-form is not bound to...

I have a sub-form that users can change the records displayed by choosing from 2 3-button option groups. I then use two nested select cases to choose an sql statement for the recordsource of the sub form. I want users to be able to enter dates into 2 fields. When I use the SQL in a query, the...

Oh, wow. That is awesome :) :) :) Does exactly what I want it to :) Thanks. I knew it must be doable, but I hadn't got a clue how to do it. Now I just need to analyse what it actually does and how it works - but I think I'll sleep first...

I am running on too much caffeine and too little sleep at the moment, and I can't work out whether what I am trying to do is really complicated or whether I'm just missing something really obvious...? I have a table which tracks positions held by volunteers within various organisations. Each...

All done. Incidentally, the linked table manager spat out a table that contained a calculated field. When I deleted the relevant field (an old legacy - I don't use them any more) it went through fine. Is that standard?

I guess I'm just I'm scared of deleting all my forms, queries and suchlike - it goes against the grain :eek:

If you are splitting an existing single-user DB into a multi-user FB/BE db, is it necessary to delete the forms, reports etc on the BE. The only one I can think of would be to stop someone trying to use the BE directly by mistake, but file permissions should handle that. Is there a downside...

At the time - around 2014 - it was the only low cost (I was building a db for a club where users are all volunteers spread all over the UK - so no funds to speak of) method that I could find to allow multiple users to access the data over the internet (seeing as the so-called access web database...

I think that a hazy light might be starting to peek through the clouds of ignorance... I don't think I've been understanding exactly how and when I was doing that. So if I now understand this right, the line: datStartDate1 = Format(datStartDate1, "mm/dd/yyyy") is taking a date variable...

That does the job. Ta :)

Oh, yes. It wasn't my example, it was Gasman's. I was replying. No. No. No. :banghead: Yes. That is what I want to know how to do? I am currently using this: datStartDate1 = DateSerial(Switch(Month(Date) > 4, Year(Date), True, Year(Date) - 1), 4, 30) datEndDate1 =...

Ok, so I guess I shouldn't be using Format if that's converting the date to a string (yes, datEndDate is declared as a date - I wasn't even aware that you could format a declared date variable into a string; I thought the whole point of declaring a specific variable type was that it would only...

Ok. Thanks. I think I get that. However, I still don't understand why: datStartDate1 = Format(datStartDate1, "mm/dd/yyyy") datEndDate1 = Format(datEndDate1, "mm/dd/yyyy") MsgBox datStartDate1 & " " & datEndDate1 returns "30/04/2019...

I tried this: Sub testType() Dim dtStart As Date, strStart As String dtStart = DateSerial(2018, 11, 22) Debug.Print dtStart dtStart = Format(dtStart, "dd-mmm-yyyy") Debug.Print dtStart strStart = Format(dtStart, "dd-mmm-yyyy") Debug.Print strStart dtStart = Format(dtStart, "mm/dd/yyyy")...