Search results

Hi, I have a database that opens into a continuous form ... which has records and a user name in each, which is taken from a table "ASSIGNED". At the foot of the continuous form I put a filter button to show only the selected user records. What I need is: That when opening the form, Access...

Hello, I would use the Access 2007/2013 Attachments data, but would like to understand where to store data? You can specify that the store in a location that I specify? for example c: \ reports \ attachments? thanks

Hello everyone! I consulted: I have a continuous form, where each record shows, has several data ... (Given that I can not place a subform ...) What I need is: Adding a subform or table or something that allows me to (just like rows with two columns) add two fields (columns), DATE and...

Hi, I have a button on a FORM to print the current record with the following code: DoCmd.RunCommand acCmdSelectRecord DoCmd.PrintOut acSelection But what I need is that before printing, open the preview to set the margins and page size ... or at least to pre-configure so that when...

excellent!!! You are a geniussss!!!! Thanks very very much!!

CheckBox to change the color of a control Hi, I have a CheckBox and a Field Date. The latter has two conditions: If it is >=now() to be the font is RED and if <=Now() that the font is GREEN Now, what I need is that pressing the CheckBox, ignore both conditions and that the font color is set...

Thank you all for your answers! I screw around with this and I got to thinking .. and ... I do not know if I expressed myself very badly, but I did this and it worked Private Sub Complete_Click() If Complete.Value = -1 Then Me.STATUS= 2 Else Me.STATUS= 1 End If End Sub this can bring...

Take this opportunity to ask a question related .. How do I make: if the checkbox is marked, requires the user to place the date in a date field that is in the same form?

---------------------------------------------------------------------------------------- Hi, thanks for responding! Yes, Combobox selected value is stored in a table for each record. and yes, I want one is the reflection of the other ... can be done?

Hi, thanks for responding! Yes, Combobox selected value is stored in a table for each record. and yes, I want one is the reflection of the other ... can be done?

Hello everyone! I have a form with a combo box (it has two states (In process / On file)) and a checkbox and I need that when the checkbox is checked, change the status of the combo box ... The combobox and checkbox are in different tables (Assigned and Movements, respectively) and refer...

Apologies, I'm newbie .. You could say a little more about where to place each thing? Thank you!! DMX.-

Hello! I have a SubForm "assignments" based on a Query, which has criteria to filter dates and also to filter 0 and 1 of the checkbox ... The question is: How do I put in that SubForm one or more Checkbox to "enable" and "disable", only the criteria of such query? So, toggle, for example...

Hello! I have a SubForm "assignments" based on a Query, which has criteria to filter dates and also to filter 0 and 1 of the checkbox ... The question is: How do I put in that SubForm one or more Checkbox to "enable" and "disable", only the criteria of such query? So, toggle, for example...

Solved! The problem was the \ and the number of the bound column ... was in my nostrils :banghead: LOL Thanks to everyone!!!!

Not working :(

Thank for reply! NO WAY ... I try this: Private Sub Comando26_Click() Dim carpeta As String carpeta = "P:\Documents WORD" & Me.[Assigned to:].Column(2) Dim Retval Retval = Shell("explorer.EXE /e, /root, """ & carpeta & """", 1) End Sub ... and sends me to "P:\Documents WORD" but not, for...

Hello, thank for reply! no way! adding &Me.Username, open the folder "My Documents", not the folder with the name of the field. UserName is a combobox was created with the wizard searches (taking data from another table "People"), in the design of the table, will be for that? Help!! Thanks

Open a specific Windows Folder Hello everyone! I am using this code to open a specific Windows folder ..... and it works perfect: ---------------------------------------------------------------------------------------- As String Dim folder folder = "c: \ Documents WORD" Dim Retval Retval =...

Hello to everyone!!! Hi, I'm new to acces and eager to learn in the wake of the problems that arise...