Search results

Hello, I don't know how to search for what I am looking for. I keep ending up at the 'watercooler' looking at jokes and religious comments :) SITUATION: I have a form that accepts text info for insert into a table's record. Further, there is a multi select listbox that upon completion of the...

I'm digesting this now... A quick glance looks like the (non file spec) solution is to concatenate the values delimited by pipes, then write to file... Freefile? Just had to look that up... :) Thanks for the push!

Hello, Is there a way to do an export of a query, using pipe symbols as the delimiters, ideally using vba to do the export? When I search on this topic I only see ways involving file specifications. Sadly, to begin with there is no "File --> Export" in my Office 2010 so it's a non starter, at...

A pirate walks into a bar with a steering wheel in his pants. The bartender says "Hey buddy, you know you have a steering wheel in your pants?" To which the pirate replies "Aye, it's driving me nuts!"

Thank you! You're absolutely right! - I had a 'Paste Errors" table created when messing with data and suddenly I couldn't through the line: tdf.Connect = sConnect without getting an error 3219... It was the local table attempted to being connected to! Did I already say thanks? :)

Oh, and for the record, I had to edit the IF line to include an wildcard: If Not (tdf.Name Like "MSys*" Or tdf.Name Like "~*") Then

Doh! removed: Set tdf = tdf.Name ...and I'm good to go. Thanks anyway!

Hello, Trying to finally learn DSNless connections... :) This works fine, to connect me to a single named table: '####### DSNless Connection ####### Dim sConnect As String sConnect = "ODBC;DRIVER={sql server};DATABASE=PrioPlansDB3;SERVER=Alex;Trusted_Connection=Yes;" Dim...

Hello, Yes, I agree that would be a better way, export query to excel file... :) But I'm choosing to beat my head against the wall for a few minutes here in hopes of understanding why this one report doesn't work as the others do. It's a commercial MS Access contact management/meeting...

Hello! Happy New Year! :) Question: I have this one report (doesn't happen on others in the same mdb) that when a user (or me) presses the export to excel button while viewing the report in preview mode the process doesn't export the data to an xls file. The wizard runs, the process...

In the end, I ended up having to check if the dates are blank, and if so, not include them in the insert query. This feels lame, and of course if someone has date info, and then removes these dates on purpose, then using this "method" will fail to remove the dates when the record is updated...

...and also MarkK, thanks for the tip re the above and QueryDef... That is a new thing for me. I'll give it some serious looking over when I make a new app (sadly, self taught here) - which should be in a few weeks - if I can just finish this one :)

Ok, so now I'm here... "', " & _ IIf(Nz(dtmStart, "") = "", "", Chr(35) & dtmStart & Chr(35)) & _ ", " & _ IIf(Nz(dtmEnd, "") = "", "", Chr(35) & dtmEnd & Chr(35)) & _ ", '" & _ and when I have blank dates using the above I get this for a string check...

CJ, Thanks... I'm closer? "', " & _ IIf(dtmStart Is Null, "", Chr(35) & dtmStart & Chr(35)) & _ ", " & _ IIf(dtmEnd Is Null, "", Chr(35) & dtmEnd & Chr(35)) & _ ", '" & _ ...but now I get Runtime err 424, Object required. When I debug, the whole...

Hello, Ok, I had to have done this some time in the past... and yet I can't today, and I'm going to pull my hair out! I have a form with a series of unbound text boxes where data is entered - including two non-required dates. If I use the date picker to choose a date, this works fine, but...

THAT WAS IT! I removed format(), [which I think I was doing to turn null into blank some old habit so I wouldn't get errors on insert...] and the clipping stopped! THANK YOU! :)

...what's also interesting is that if I paste in the long strings into the table itself in access (not using the form) the long text is successful in making its way to the backend. What's odd is that the txt field on the form allows me to paste in the great than 255 chars, but it seems to be...

The form is using all unbound items, and the inserts/updates are using VBA. e.g.: Private Sub btnAddNewRecord_Click() If Format(Trim(txtStratGoalName)) <> "" Then Dim strSQL As String strSQL = "INSERT INTO dbo_StrategicGoals (StratGoaltypeIDf, StratGoalName...

Hello, Ok, i thought I had this handled - but alas I don't... My text boxes are still truncating at 255 characters. To reminder us, I'm using MS Access 2010, with sql server 2012 backend. The description fields on the backend are varchar(2000) in the tables that the access front end is linked...

...also, I chose not to update the mdb's to accdb since that doesn't support workgroup security. After converting the mdb's and mdw's to access2002-3 version I was all set for Off2013.