Search results

Its a sample data that should be look like. In a way I am seeking help on how to enter it at one using a form. The form is like the attached file. how in number text field can enter a multiple id???!!!

Here is a sample data that should be entered in a table. In a form: There is one field for all of these fields. For Numbers column, putting it in block or all at once. But how can we deal with the time? per processed orders? It is possible to enter all at once but how can we capture the...

For every processed orders, there should be a start time and time to capture the real-time of processing that order. If there will be a block of inputs, i dont know how to deal the processing time of each reference ID.

Yes exactly

It's like this, Reference ID Numbers DocIDA1 001 DocIDA1 002 DocIDA1 003 DocIDB2 A01 DocIDB2 A02 There is 1 field for Reference ID and a table(which i am still thinking on how ill i enter it all at once) for inputting...

I want to make a table where in I have to input atleast 10 numbers in one reference ID which there is a start time and end time. Can someone give me an idea on how to do it? A form with inputing one reference ID and then adding multiple numbers at once and saving the data with a start time and...

I have Main Table with a count and I have a query from it. But when I looked at it, the data doesn't match. What may seems to be the problem? It is all Grouped By. i cant attached the file for it is too big. Thanks.

omg! that was a mess.. i forgot, i was using both access and excel at the same time, i have both forums for it.. thinking i was in excel.. thanks for that bang anyways!:banghead:

I have this Sheet1 which is a manual input, I need to copy the values from Sheet 1 to Sheet 3, then I have Sheet 2 where there is data auto generated, How can I vlookup values copied from Sheet 1 and find it in Sheet2 ??? Is it possible using the vba code? I should find the values copied from...

Thanks for all the help.

Is there any ways that can convert Date: In the form, the text field will always accept a format which is DD-MM-YYYY then when it is saved in the Table the output should be converted to MM/DD/YY Or M/D/YYYY. Disregarding that 04-07-2013 should be 7/4/2013 and not 4/7/2013. Is that...

Under Form Properties: my textfield name is: txtDate Format: Short Date Table Properties: Data Type: Date/Time Format: Short Date In codes: rst("Date Released") = txtDate.Value Is that what you mean??

Hi All, I already got it, my problem now is even the date fields shows data conversion error. If the Date Field has date, it doesnt have errors but if the Date Field is empty it shows that the Data Conversion Error. How would i solve it? Thanks.

I am having trouble in editing my program. I have this table and form. I have to input from a form [decimal in percent] (ex. 99.45%), to be added in my table. How can I add that, I am using MS Access 2007. What code should I used and do I have to change the data types in my table. This is the...

Ive done it. You have to create another query where the contents will be the grp fields and the MAX. Then connect that query into your table. the best way is to connect with the TransId. and thats it. This info is for future reference. I will now closed this thread.

Can you explain it further by step by steps on how will i do it.. I'm still confused on how to make it the right way that you have suggested. Thanks.

Can you explain it further by step by steps on how will i do it.. I'm still confused on how to make it the right way that you have suggested. Thanks.

I tried using MAX but still it won't display the last item it had entered the database. This is an example of the item i am looking. The MainTable shows almost 8 items The QueryTable should display the very last item that it will see.. but id doesnt display it.. This is the design...

I have a query table from a main table. It has different fields. I am having problem with my table. I have a ProjectNum Total to GroupBy and the remaining fields are total to "Last". The problem is according to the main table the last production is 6/17 but the data the query table is getting...

It works perfectly. Thanks. :)