Search results

yes this is all one field. however, it's a concatenation of many fields that have different data type. 2L1, for example, has three fields itself - itemid (text), bundle (text) and operation (number). the entire ticket contains many more fields however: e.g. 22 M R1 2L1 20 22 M R1 2L10 20 22 M...

thank you very much. yes, i understand why, but is there an easy way to overcome this?? ameen

hello. when i query data in a text field the operation (e.g. 2L1) order gets mixed up. tickets 10, 11, and 12 are read before 2, 3, 4, 5, 6, 7, 8, and 9. any ideas?? 22 M R1 2L1 20 22 M R1 2L10 20 22 M R1 2L11 20 22 M R1 2L12 20 22 M R1 2L2 20 22 M R1 2L3 20 22 M R1 2L4 20 22 M R1 2L5 20 22 M...

the reason i wanted to use this is so i can actually have a query run. when i use docmd.openquery in vba or even open a query myself manually, access opens the query without running it so i don't have updated information. My problem is that the query is not updated based on new values entered...

Hello i cannot get this statement to execute in vba: Private Sub Operation_AfterUpdate() DoCmd.RunSQL ("SELECT Last(UnitRate.UnitRate) AS LastOfUnitRate FROM UnitRate RIGHT JOIN EmpTicket ON UnitRate.Operation = EmpTicket.Operation;") End Sub i get the error: a run sql action requires an...

Hello. I am trying to assign many values to one of my fields, TicketScan. Some values will be from a main form (Roll) and some on the subform (Bundle)that the TicketScan field is in itself. These are the values i would like to concatenate: Form_Roll Objects: RollID TotalUnits MarkerType...

Hello. I am having trouble using a multiselect textbox. Initially, i was using a regular combo box to capture information for clients. In the combobox, only 1 value could be selected from the list. I currently have 40 clients that have only one value recorded for the 'business type' field. Now...

I am trying to Open a subform on the last record each time the main form records are navigated when i try the following: Private Sub Form_Current() DoCmd.GoToRecord , , acLast End Sub it works, but the record is locked, i cant add new record or navigate. when i try this command...

how do i run a query to pull up the records that are affiliated with the last date of entry. i have a field called 'process date' to capture date, but i need to bring up the records that are the latest so i can display their current status. i don't want to do it by lastrecord because some...

Hello. I am trying to update the value on my Client Stages (main form). The value should be equal to the Name field on my Service Provider (subform). Once the name value is recorded in the subform i would like this value to appear in the SP Name field in my main form. How would i do this...

ok i got it to work somehow. the main form works fine, but i can't get the subforms to work. if i open the subforms individually they work fine (you can click in the fields and the mouse scroll is disabled). However, when i access the subform from the main form (by opening the main form) the...

no. i have set all of the references and still same error. any ideas?? thanks.

i have looked at the link and it works great for the sample db. but i can't get it to work in my db. i keep getting the message: "The expression On Load you entered as the event property setting produced the following error: User-defined type not defined *the expression may not result in...

i am trying to disable scrolling functions caused by the mouse. each time i use the middle scrolling button on the mouse it scrolls through all the records each time it is rolled upward or downward. how do i disable this function? thanks. ameen

i am trying to setfocus from a subform to another form . i keep getting the message: "cannot find the form 'Grants' referred to in a macro expression or visual basic code." and i know that the form 'Grants' is open. Since i am in a subform (Client Stages) i tried to setfocus in the main form...

hello i am trying to base the value of a field on date which is entered by the user. so if 'date_received' is entered as 1/23/03, i would like the value of the field 'past1' to equal 2001, 'past2' to 2002, etc. is there a way to separate out the year to execute this calculation? thanks. ameen

i need to import lots of data into access from text delimited files. Many of the source dbs that i am importing from have one 'contact' field for the name, which combines first, last, and middle. in my access db i have 3 separate fields for this because if i need to look up alphabetically i can...

Hello. I am trying to display data from 3 queries in a report which shows quarterly data. i am having trouble displaying the query that pulls the quarterly data per year. i would like it to be as: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Totals in five columns and have the data be...

so i can make a calculation in a report by summing two fields in two different subreports?

i am trying to execute a query that sums two fields in a table of quarterly data. field one: the sum of all 4 quarters for [employees that left that quarter] for a particular year. so i need to sum this field for all 4 quarters. field two: the sum of [total employees] that are only in...