Search results

Solid demo. Thanks for sharing this with us. Very helpful! (y)

How many potatoes does it take to kill an Irishman?

What do you call a prostitute with a runny nose?

Post the SQL and let us help. Is your db contained into one file, split between FRONT END and BACK END - and if so, is the BE still an accdb file?

Hmmm... I did see something along the lines of checking once string character is number, keep reading next string value if numeric, else if last value was numeric, insert pipe | operator, then after reading entire string, replace all non [0-9] characters with " ", then replace " " with "", or...

And i ask because it seemed the most difficult part was determining the last number in its entirety versus being the only number… i don’t have my pc to test anything right now, but as much as this has itched my noggin, you have me just as curious as to the details i was asking about in the post...

Hey Isaac, could you specify the below a little more? Like how are these columns populated, are you populating the columns, are you importing the data into columns, etc…. I guess i ask also because sometimes it seems you have one number or two… i’ll see what i can come up with.. asdf asdf #...

Here is an updated answer that should work for you. And no ambiguity on your part - it is my Friday afternoon brain fog! Reverse was a new one for me. I have never had to use it in T-SQL string manipulation before. DECLARE @stringvalue varchar(max) = 'asdf asdf 2222 # to 744 # asdf asdf asdf'...

If you you mean actual numbers then 1 or 2 would work, if you do mean #'s then 3 or 4. ---EDIT: UNSOLVED.... I need to fix #1 DECLARE @stringvalue varchar(max) = 'asdf asdf 2 # to 74 # asdf asdf asdf' SELECT CASE WHEN PATINDEX('%[0-9]%', @stringvalue) = 0 THEN NULL ELSE...

Some ODBC drivers can also be bit specific. I have to connect to an older IBM database and the only driver my IT could find was 32 bit. When I got a new 64 bit laptop, they gave me 64 bit Office, but I had to change it back to 32 bit Office just to be able to still connect to the IBM db via the...

One good use is if you have a lot of SQL database changes to make. Rather than hardcoding table names in a script, you can have the names of the objects in a table, and then iterate through to perform whatever truncate, copy, call sp's, etc. for each object name value in the table.

Understood. I hope this didn't come across as needing to be posted in Site Complaints instead of Site Suggestions - I only asked out of curiosity, and maybe I shouldn't even be asking this question here. It is almost like searching inside a database on your local machine from windows explorer...

I just started using that bookmark feature yesterday. That should come in handy. And @The_Doc_Man that explains it perfectly. I was just curious and have no idea how forum software such as Xenforo works. At first thought it seemed it would be easier to search all of our internal text versus an...

Hey AWF, Do we include attachment & inserted tagged code in our site searches, and if not, is it possible? I've been trying to search things on this site for the last month or two, who knows, one month feels like two months and then the next thing that you know, two months go by and it is only...

Have you tried changing the sourceobject for the subform on frm_Main? You could have a hidden unbound text box on your frm_Main and set the value of it with the subform button click and then with the frm_ProductHoldData open/load event you could filter the recordsource with the text box value...

That color was because it thought the code was SASS, just noticed the tag and fixed. This is real people and stations - There is crosstraining/station rotation throughout the day, but in some cases an associate is fixed to the 1 station for the entire shift, and other stations will all rotate...

Hey AWF, I'm wondering how I can cycle through a set number of lets say 10 seats numbered 1-10, with 10 alphabetic names of A:J, and they are left to right. In this case, people will shift a seat to the right, but not everyone, and I need to record their new seat number. Is there an efficient...

I've just encountered this with a database user as well. From the Access Form once they click the command button to send the email, the outlook new message screen pops up with the attachment attached, and they click send, thinking everything is working as normal. Well today rolls around they...

I have, I mean I'm no stranger to the answer being right in front of me, but I haven't seen where the setting/option/selection is. EDIT ---- AHH - so if you right click "All Access Objects" or the navigation pane header, go to view by, and details. Finally!!!!

Hey AWF, Just curious why and how objects appear differently in the navigation pane. I haven't seen a setting to modify under navigation options, but sometimes I look at sample databases and the objects are much bigger with more detail associated with them as shown in pic #1. If i create a new...