Search results

Hi All, I have split my application into back end (tables) and front end (forms/queries/reports) successfully over the network. It's working perfectly. Now, I need to add or rather import an excel sheet into the backend as a table. How do I do it ? And how to refresh the links from the front...

Thank you. You are right. My idea is to get the stack of rows one below the other ! And thanks for clarifying on the other suggestion too. Appreciate it. :)

Hello. I have a table, on which I have two queries with different conditions - that result in the same resulting columns. Is there a way to combine these two queries so that it appears as one resultant set of records ? As of now, I run two queries, then export to excel twice and copy/paste...

Thank you.

Hi, How can I set up the result of a query (in datasheet view) to have it's columns in best fit mode automatically ? I mean to say, the column widths set according to the contents/characters in each field. Doing it manually each time it tedious. Any help appreciated.:confused:

Thank you all. I work in an envi. where online help system for all Ms-office products is unavailable. Anyway, I'll try to tweak and see.

Hi All. How do I setup the Access 2010 help system, so that I get relevant answers ? It was so good & user friendly with Access 2007. With Access 2010, if I search for say Datevalue() or Format(), I get directed to some useless help text where the keywords I use don't reflect at all ! It's...

Your suggestion worked. Thank you so much ! At each user's PC I need to allow them access to some forms only as per their work. Other queries and reports are not necessary in the db_fe. If I delete the queries and reports, can I still compile the DB at user end and make it an ACCDE file ...

Thank you very much. I did it this way, once before and it worked. I'll try it again.

Hi. I have developed an Access 2010 application that needs to be used by 3-4 users everyday. So, I copied the file to the network folder location and tried to split the db. The backend file got created. Then, on each user's PC I tried to create a shortcut to the frontend file located on the...

Thank you all so much ! I'll try and do what is best applicable. Regards...

Good Idea ! But I use Ms-Access to create custom reports. And collecting data in several reports through Excel, importing it next into Access for all the 27 Branch offices is a task that I prefer to be automated; if possible. Thanks.

Hi All. The scenario is as follows : I have several branch offices from where I get data each month. They send it as excel files. But it's tedious to download, convert and store them into my Access database. And sometimes the column names are wrong or data not entered properly etc So, I've...

Thanks a lot.

Hi All. I'm going numb on this. Sound's silly but I'm stuck. I need to fetch records from a table using a query.A file moves from one officer to another and I track it using Access 2010. My query is as select file_no,file_name,off1_datein,off1_dateout,off2_datein,off2_dateout,.... from...

Thanks a lot. Let me try that and see !!

I mean, how to send all the 10 records entered (in HTML or TEXT format) to a particular recipient ( email address ) when the users finishes entering his records and clicks a submit button ? This is what I plan to build. I need this feature because, users need to send me records every week from...

Hi All ! I have a form that accepts records in a tabular format. And I wish to implement the following: Once the user is done with entering records, say after10 records, he clicks a submit button to send all the 10 records via email. Is this possible ? If yes, how ?? Please help.

ok, I wasn't clear. I wish to use the "Collect data via email" feature in Access. But each time the user can fill only one record and send as a reply, which will get auto appended to the Access table at my end. I wish to know if the user can submit multiple records, instead of just one.

Hello, Is it possible to create and send a form to users, so that they can input data into the form (multiple records) and submit them via email (outlook) each month ? Any help appreciated.