Search results

Hi, I need to open from a form a specific folder where will match only the first 3 letters. Example: On the form I have a field named [CompanyName] and in this example [CompanyName]="ABC Customer" On the server, the folder name for this Customer is only ABC (without Customer) To open this...

Hi, I have a form “Tools List” based on a query “Tools List Query” I need to filter more fields on the form using a combo box for each field. As example to filter “Radius” field I’m using cbo_Radius and in the criteria query: Is Null Or Like [Forms]![Tools List]![cbo_Radius] & "*" The...

Hi, I have a table ordered by operation number ON, with others two fields Department, and ETD (Estimated time) I need to make an update query to change the ETD values where the department Milling CNC or Lathe CNC will appear two times. For example op no 80 and the next 100 are in the same...

Hi, I have a form with a combo box [Operator] where the Auto expand propriety = No. I added an event "On not in list" me.operator="" When a user tape a value which is not in the list, after press on enter the field will become empty (which is ok) and the message "The text you entered isn't an...

Hi, I have a basic form and for entering data, I have to use a keypad (numbers section only) which include a backspace key too. When a user made a mistake in a specific field, can use the backspace key to correct it but can't move to previous field to make a correction. I don't know if is...

Hi, I have a query named “PSAET” with those fields and values: I need to add a new calculated field named “ETAD” which will accumulate the ETD field and the result should be like this: To do this, I created a new query and if I have only one batch, my formula is working fine: ETAD...

Hi, I have a form where I need a conditional formatting on a field [TT]. So if I use a basic way to do it (condition 1), the expression is [CAV]-[TTA]>0 is working fine and the back color become green as I need. I can't use that way, because this is an indicator which I don't want to show all...

Hi I have a form where I need to verify if two specific fields [Field1] AND [Field2] are filtered. In the other words I need a code something like: If me.field1 AND me.field2 are filtered Then Msgbox "Filter is On" Else Msgbox "Filter is Off" End If Can you help please? Thank You!

Hi, I have a form where I need to apply two filters one at the time, using two cbo box: cbo_State for the field State and cbo_Status for the field Status. I tried this, but doesn't work: For State: Private Sub cbo_State_AfterUpdate() If Me.FilterOn = True Then Me.Filter = "State= " &...

Hi, I have a query named BBT with those fields: Qty, S_Time, M_Time, Planned_Date I need to calculate in a new field AT: DSum("[TT]","BBT", [Planned_Date]<=#" & [Planned_Date] & "#") but for some reasons doesn't work. The field TT is a calculated field too; TT: [S_Time]+ (Qty]*[M_Time] Can...

Hi, I’m not a programmer, but I did a lot of research and I don’t found what I need. I hope that You can help me! This is what I need: I have more pdf searchable, all located in the same folder location. (Ex: C:\Temp) From an Access form, I like to find all the pdf files located in...

Hi, I have a table "Preference" where I can select (Yes or No) the desired columns to be display in a form "Presentation" where are A, B, C, D and E columns. What I need: If for example in the table Preference the column selected are A, C and D, then the form will show only those three columns...

Hi, I have a very basic union query. I use it to merge the rows from others 10 queries. When I run the union query is working fine, if I use it for max 7 queries. If I add more than 7, I get the error: “System resource exceeded.” Here is the code of my union query: SELECT...

Hi, I have a very basic application to manage the tasks. In the main form "Tasks" one of the field is the priority (Order by) and I have this example: Task Priority B 1 A 2 C 3 E 4 D 5 If the user change one priority, I need a...

Hi, I have a form with more records lines. For each record I have a button what will open a specific file if exist. Dim strFoldername As String strFoldername = Me.Scan If Dir("M:\Applications Access\Credit autorisations\Documents\" & strFoldername, vbDirectory) = "" Then MsgBox...

Hi, I'm new here and new Access user. I'm looking for an easiest solution to combine more records into one, using comma delimited. Let’s say that I have a table T1 with two columns Code and Client like this: Code Client X C1 X C2 Y C1 Y C3 Z C1 Z C2 Z C4 Z C5 i need to see those records...