Search results

Hi. How do I suppress (not display) the empty fields in detail section of my report ? Table structure is as: Order_id, Order_Value, Tax1_Amt, Tax2_Amt, Tax3_Amt Report format is as: Ord_id : Ord1001 Ord_val : 500000 Tax1_Amt : 12000 Tax2_Amt : 3650 Ord_id : Ord1003 Ord_val : 965000...

Hello ! 1) I created a simple report using the wizard. It's in landscape mode. On screen it shows all fields within, but when I print it; I see that the last field with part of its data is spilled onto page 2. I've tried to adjust page margins etc, reduced the fonts etc., but still does not...

Hi. I have a form in which I fill some fields (3 text boxes, 2 combo boxes). The last field is also a text field (255 chars) that needs to be populated based on the other fields. It's like a string concatenated. The fields are date_in, date_out, item_name, status. My code is as follows ...

Hi. How can I clear all the contents entered during data entry fields on a form, after say I enter 8 of the 15 fields on a form ? What I mean is, I dont want that record to be entered. Access defaults to filling a record partly in the underlying table, as I am using a bound form. Is there a...

Hi, I have a Dlookup code on a field in a form. It fires properly and finds if a value already exists in the underlying table or not. And a msg box pops up are as per my code. But, it behaves erratically. Sometimes, it does not find a value that exists in the field at all. I need to refresh...

Hi. Is it possible to get a query result (grouped) as follows: ? Itemcode,Itemname,QtyOrdered,DateOrdered ( are the fields) S100, Shoes,150, 12-jun-16 .....................200, 14-may-17 .....................300, 22-sep-17...

Hi. I have a table that records material received. The main fields are MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status. Any material can come any number of times in a month. Each time it comes, it is stored as a record. Example : MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status M121, Steel...

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...

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...

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:

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...

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...

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...

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...

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.

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.

I know this is simple, but I'm lost ! I have two tables A and B. Both have a common field PO_NUM. My query is supposed to get 3 fields from table A and 5 fields from table B. Condition is : Only those records that have a matching PO_NUM in both tables plus one field in table B must match user...

Hi All. I have an excel file that needs to be imported into access. I get error when importing as one column is general type in excel, but stores mostly date values ( in dd-mmm-yyyy format.) Some of the records in that column in excel have text values like "till delivery date", "upto...

Hi all. I have a query that appends 5 tables with 2 columns of same name. The query runs fine. But how do I move it into a new table with the select into option ? I get an error that it does not work with an action query ? Please help. my query : select order_id, part_num from a, union...

Hi all. I have a form based on a table with about 15 fields. Based on user input, I need to keep adding records. It could be say 5, 10 or 20 records in a grid like display on the form. Out of the 15 fields, some 8 need to be in the grid like interface as they may be repeating values. The rest...