Search results

Try changing in the table from General number to Fixed and Decimal places 0 Cheers! Goh

Hi Jennesa, I hate syntax, do you hate syntax? MS Access LOVES syntax, in fact it DEMANDS syntax be 100% correct or it will do screwy things to you on purpose, especially give you errors that are so cryptic that they are hard to decipher. The only way you get used to such antics from MS Access...

Large Text Field should then be Type: LONG TEXT (Memo) Cheers! Goh

And is the TextBox outline expanded as you'd expect it to be? If the textbox is open for 4 lines then I'm thinking a layered object maybe covering the space that the Textbox grew into. Maybe you better post a Screenshot. Cheers! Goh

DCount("[RecDate]", "MyRecordsTable", "[Survey] = 'No' AND [RecDate] + 14 <= date()") Cheers Goh

Just tried opening it with 2013 and it works. Could be an issue with 2016 not liking older .mdb files so, if you have an earlier version then use that to open the file and upgrade it to an accdb so that you can access it with your MS Access 2016. Cheers! Goh or maybe somebody could do that for...

You are confusing Recordset commands. It goes like this While Not rs1.EOF 'Start from the first record in rs1 thru the END of rs1 'Do something here while on the current record of rs1 rs1.MoveNext 'go to next record in rs1 Wend 'Exit the loop when you get to the end of rs1 Cheers! Goh

Does the Print Preview show the whole field or the truncated field? Goh

F11 to see tables, queries and other objects ALT+F11 to See code Cheers! Goh

In addition to the FIELD /TEXTBOX property CAN GROW = YES you have to set the property for the section to CAN GROW = YES Cheers! Goh

You could name your range of dates B6:B454 as PatientDates and you range of TimeElapsed C6:C454 as PatientConsultTime. Once you have the alias naming convention set up it will always represent that range no matter where you drag the formula to. Then name the Date Cell as SelectedDate...

LOL, The dude is "so" thankful for an active forum that posts useful advice and solutions that he is overdoing it a bit. Same happened here for each of my posts yesterday and he/she "thanks" the person who asked the question to which I was responding, too. Maybe the guy/gal is sincere, but it...

since it doesn't like the name of that property, would that be the same as outline level? https://msdn.microsoft.com/en-us/library/office/ff194690.aspx Cheers! Goh

Use the GetObject function when there is a current instance of the object, use CreateObject to startup a separate instance... if you have a single instance of Outlook open and it's doing other things automatically like, checking for mail from your ISP every 5 minutes this could cause a conflict...

Cut my teeth on the WANG 3300 and Fortran IV Now piloting thru Access 2013 and beyond... Welcome to the forum. Cheers! Goh

Replace Method: https://support.office.com/en-us/article/Replace-Function-6acf209b-01b7-4078-b4b8-e0a4ef67d181 Cheers! Goh

If the form is actually NOT LOADED you can't focus on it nor on it's associated controls. LOAD/OPEN the form (A) from (B), setfocus on the Form (A) and on the control (in A) and execute searchforrecord from (B) then close your current form (B), leaving the recently Loaded form(A) in view. Does...

Order of Operations from LEFT to RIGHT = PEMDAS, see : http://www.purplemath.com/modules/orderops.htm

Make a Table with 1 field to capture File Names For example: tempFileNames (Field: BuildSheet) Put these pieces of code in a module. IsBlank() is good for lots of things. Function checkFilesIn(FolderPath) Dim FileName As String, strSQL As String ' Pick the First FileName in the chosen Folder...

DoCmd.gotorecord,,acLast after adding a NEWRecord will raise that error since you are already on the LAST record. Jog the cursor position by moving to a Previous record or to the First record then back to the Last. Let us know if that helps... Cheers! Goh