Search results

just missing the word "function" public function fnWordCount(sString As String, Optional iMaxLen As Integer = 6) As Integer excellent little loop arnelgp , I was thinking of just replacing spaces with commas and then entering each into an array and then loop the array. But I like yours better...

Yes I very much intend on sorting Colin with the licence that we discussed. I have no problem with this. I was simply in the process of making a more stable build for Colin to be able to use as there were some glaring bugs that needed ironing out. No point in handing out a licence to something...

Hi The_Doc_Man I'm more interested in getting user feedback. The mechanism for this software to be purchased is indeed there however I do not have that level of confidence to go ahead with a full release. Obviously commercial software is not allowed here but as this tool box is not fully ready...

Free Microsoft Access Add-in ProcessTools (BETA Version only) To get the full BETA Version (version 0.XXX) without the 30 day trial period simply add your email into the payment screens Payment Receipt Number. The BETA version will be free for life unless you upgrade to a newer Major version...

Welcome mate. This site is fantastic for getting feedback and help. Someone usually responds within a couple of hours even on the tricky questions.

so your query needs to know about the current main forms ID. There are many ways to do this. For me, I would create a global variable, e.g. public glng_MAIN_ID as long into a Public module then I would create a GET function so that the query can just run the function and collect the ID...

There are some great tools in the ProcessTools Addin. It's free for 30 days then it's only $10 US plus tax. So free and cheap at the same time. Link: https://processit.co.nz/processtools.htm

Welcome! This community is amazing. I'm sure you will learn much from everyone here. I'm James and I'm from New Zealand. Nice to meet you AleXX

there is a limit of 754 controls that can exist on any singular form. Access will cry if you do any more. I think the answer lies in correctly defining what it is that you really want to see. If you want to see each record in the table then simply drag the table onto your form and have an...

Hi, when you select your checkbox do you store the boolean value in a table or global variable? Is it important that the next time you open this database you see you checkbox value again? If so then it should be stored in a table otherwise you can store your check box value in a global...

Hi! Welcome

DoCmd.OpenQuery "yourQueryName", acViewNormal, acEdit OR CurrentDb.OpenRecordset("yourQueryName") Or CurrentDb.Execute "yourQueryName" depending on what you are doing with it

Simply rerun the query then. Once a record is saved to the table the query will be able to read it, just re-run the query.

Or limit the character length that can be entered for the report to something reasonable and you won't have to do any resizing at all :)

You need a reset mechanisim perhaps a button or a checkbox or something to reset the country and city recordsources to what I've typed below or something similar. So your first Combo box should have a recordsource Select Country ID, Country from "your country table" the second combo...

Hi I would love to help. Is the query you speak of the recordsource for your saveform? What type of query is your query and what does it do? is your query the recordsource of a subform? perhaps all you need is CurrentDb.Execute "YOUR QUERY NAME HERE"

Hi, not 100% but try [Timestamp] = FORMAT(Now(), "yyyy/mm/dd hh:mm:ss") - or however you want to format this

frmJournalEntry form : Private Sub Form_Current() Me.JournalEntryDescription.SetFocus End Sub Private Sub CmdSave_Click() If Me.JournalEntryDescription = vbNullString Or IsNull(Me.JournalEntryDescription) Then Me.JournalEntryDescription.SetFocus MsgBox "Please Enter a...

First set the can grow property of the text box on the report to true then your vba code should have "NZ(strText)" which will, in the case that you have null value in your table, set the text value as vbnullstring instead and your problem will go away. i.e. Do Until TextHeight(Nz(strText)) <...

OK so perhaps you need code to catch the current ID of the record you are looking at. Then you check if that ID has changed AND is not null then you can re-query your other subforms. Option Compare Database Option Explicit DIM gVarCurID as variant ___________________________ Private Sub...