Search results

This is the structure of three tables: This is a form based on a cross tab query. Users open this form. Type a drawing number and click the filter button. A function creates a sql and use it as the record source of the table. The results are shown. If I type AL18888BC601, and select ALL in...

I've been enjoying this for a while. Just thought you may be interested too. In the link bellow, Click a decade at the bottom of the page. World wide map will be shown in the middle. (it may takes a while). Then Select a country on the map. And listen to top songs of the selected decade in the...

I have a form with a crosstab query as its source. The query and the form's data is un-editable. I want to run a function when I click on a check box on this form. But clicking the checkbox doesn't fire the event. I added a stop, a msgbox and a break point to the first line of the code, but...

Recent versions of MS Access, allows sorting properties in property sheet. My problem is sometimes sort button is hidden. If I close the form and open in it again I have the sort button. Does anybody know why sometimes sorting button is hidden? I suspect there should be a specific condition but...

This one brought tears to my eyes.

I don't like President Trump. But after watching this, I hope he win the next round.

Why do I receive this message : Is there any daily limit in liking? Am I using it too much? Should I stop liking posts even if I feel they're helping me? thanks.

I need to print a series of pdf files. If I use a loop to go through the files' names and use a shell.excecute to print them, each pdf file is opened, printed and closed. You can guess how it feels if I need to print let's say 20+ files. A google search gave me the following function, where the...

This morning I was listening to the morning news in TV while I was preparing to go and start another busy day, . Listening to a part of President Trump's yesterday speech, I was thinking he will never change. But then I was shocked when I heard him saying : The virus that came from China. I...

How can I format a date to show the hours as two digits? This is the format I use, but still the hours shows in one digits: The form is bound to a sql server database with a timestamp data type. Thanks.

If you want to check yours, Allen Browne has an utility you can use: http://allenbrowne.com/vba-CountLines.html

I feel being stupid to ask this, but how can I use power operator in vba? myVar = (Ele/2^4) Mod 2 gives me Expected: ) error. myVar = 2^4 Shows the same error too. thanks.

I'm sorry if it's old or have been discussed before. But I was so excited that even didn't bother to search for this. I always hated the Add Tables dialogue box or window in queries design view. Most of my databases has a lot of tables and it was hard to find the correct table between 50 more...

This is the structure of a table in MS SQL server: When I add this table as a linked table to a Microsoft Access database this is what I have : Apparently, Short Text is not what I need and the table doesn't behave the way I need. I can insert data into the table. No problem. SQL server...

While I’m on a PC, I can simply and quickly reply to a specific section of a post by selecting a word, a sentence or a part of a post and selecting Reply But mobile version of the software doesn’t give this option. Is there any other way to quickly comment to a part Of a post? Thanks.

Recently I’ve seen several posts that seems to be an assignment or a homework. Not only the OP has not the slightest idea what a database is, but also he doesn’t know what exactly he needs. I‘ve also seen threads where OP has asked for a detailed step by step for the solution or do it and upload...

Here, almost everybody I know or everybody I see is using iPhone. But I really can not understand why? I'm really eager to know what was the main reason you chose your device. I've been using android because: Android OS is available for use for all manufacturers free of charge. I have a...

Is there any way to make Chrome print only the first page? I print web pages maybe more than a hundred times a day. But I need to print only the first page. Every time I had to click Pages in print dialogue box, select Custom and then type 1 in Pages text box. Is there any way to automate...

It seems I'm not able to insert an image into a PM. I've seen some other members are able to. This is what I have in PM when clicking the Insert Image button. As you see, no upload button. Only URL. Is it only me? Thanks

I'm a fan of movies. In fact addicted. Although most of day I'm working, But there's not a single day I don't watch something from an available streaming channel during break time or lunch time. I mostly watch movies from Amazon, Netflix, Hulu and two others local paid services. When I don't...