Search results

SQL Server 2012 Express is also free. http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

You can't open a SQL query with 5055 characters in design view (which is what you have). It is limited to ~1500. After that, you only get SQL View.

Is that backend table showing as a linked table in the frontend and is that what you are looking at when you open the frontend? Or are you maybe looking at two different tables. From your description it sounds like maybe two different tables. The frontend should not have any tables, other...

Re: Table: Too many fields defined.- To Normalized Tables See if this helps: http://r937.com/relational.html

A bit of a reminder - fields might be NULL or an empty (zero length) string so it really depends on what is allowed in that field. If it can be either Null or an empty string, you could just create a non-showing field in your query like this: FLen:Len([FieldNameHere] & "") And then the...

Specifics for help should not be in the introductions. It should go somewhere out in the regular forum area.

Found this - I think it may solve it for you. Give it a go. http://www.access-programmers.co.uk/forums/showthread.php?t=232938

Sounds like your date is text and not numeric. Also, you really only want one record in your form?

Make sure you read the two previous posts by me, but here's a third question - Can you give me an example of one that has a problem with the space truncation issue? I'm trying to see and I can't find one.

Next question - are you using a template for export? You modified the code to have this: Set xlWSh = xlWBk.Worksheets("Feuil1") That is not correct unless you were opening an existing Excel file and this code does not open an existing Excel file. In fact, you shouldn't have had to modify...

I've just started looking but the very first thing I see, and wonder why you have this is this: Public Function ExcelExportFunction(strTQName As String, Optional strSheetName As String) ' strTQName is the name of the table or query you want to send to Excel ' strSheetName is the name of the...

So it closes it when you press F11 and when you press it again does it open it up again?

If you want the most recent date that was added, just use a query for the form's record source like: SELECT * From Transaction ORDER BY TranDte DESC

Try pressing F11.

Oops, you had a 50/50 chance and got the wrong sex. :D

Edited my original code to make it +1 instead of -1. My tests indicate it will work

You could use Dim strIn As String strIn = Me.txtSearch If Len(strIn) < 10 And Instr(1, strIn, Chr(46)) > 0 Then strIn = Replace(Replace(strIn,Chr(46), Space(10-Len(strIn)+1)), Chr(32), 0) End If It looks first to see if the text is less than 10 and if there is a period. Then it...

I'm not sure of the best way to handle that. I would probably benefit from an upload of a copy of the database.

Are you using an Excel Template file? Because your code here: Set objXL = CreateObject("Excel.Application") objXL.Visible = False Set xlWB = objXL.Workbooks.Open(CurrentProject.Path & "\" & outputFileName) is opening the outputFileName, so whatever outputFileName is that is...

Not sure that is a positive or negative statement but if it is negative, just remove all of the formatting code in that function. I don't use it myself but Bob Larson, who posted that on his site, included it (apparently so someone would have a sample of how they could do it). Do you mean...