Search results

it worked!! thanks!!!

Hi, I have a vba code for opening a form with mulitple conditions for opening a form displaying a specific record, but I'm getting a blank form as result. this is the code I'm using: DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]= " & Me.Date & " And [Supporter_Name]='" &...

in the row source of the City combo box put the query: select City from 'yourtblname' where State= [Forms]![yourformname]![Citycombobox] in the afterupfadte event of the state combobox put: me.Citycombobox.requery me.Citycombobox= "" do the same for Customer...

hi, I have 1 table with one to many relationship to other two tables (added a picture). I thought on creating a form with subform to enter the data, but the problem is that I need first to enter into the supporters table and to the Serial numbers table before entering the Error table... that's...

hi, I have a form which have a sub form. in the sub form I have a the direct table to update data on it. example: the form has the name of the project and the subform the name of one of the items of the same project and the table present the documents for the particular item. the users have the...

Hi, it's actuall an ade. file. I think it's Access 2003 program. I don't want the VBA code , I just want to edit one form. I'm sure that there is a software that does that for me.

Hi all, I have an old program with ade file extension and I would like to add some filters in one of the forms but I don't have design view or layout view option. :confused: what can I do?

hi, I will try to simply it as best as I can... I have a documents table that people are entering data into through mulitple forms. one of the colums in the table called status. I would like to receive an email when a new document is entered and when the status of an existing document is...

Hi all, Is it possible to receive an email when a row added to a specipic table? thanks in advance Karin.

Hi all, I'm trying to export a task list from SharePoint that will be a linked table to my DB. the problem is that the field "Assigned to" is extracted as a number and not a text, therefore I can't do a join to another table using this field. is anyone know what causing this or how I can fix...

gblack, the textbox called number is a text field. it's contains both numbers and letters, for example: M100

thanks for the link, but this is a list from SharePoint that a lot of people are updating every day, so I can't change the design... do you know how can I excute it in vba?

the fields names are names of presses. I need the user to choose a press name in the combobox and to get all the upgrades that are done on the selected press , therefore I can't use the field name and I need to use the reffer to the combo box...

thanks guys for your help! I tried what you suggested, but is giving me a blank results :( the code is: SELECT Karin.subject, [Forms]![Choose_Press]![press] as Upgrades FROM Karin WHERE ((([Forms]![Choose_Press]![press])="done")); not sure whats wrong...

I want to show the result of the query. I tried as your link suggeted, but the query isn't finished in the picture... I'm only using vba for this query because I want the select query to take the name of the column as in the text box. if you have an idea on how to do that in a regular query, I...

Hi all, I'm trying to create a query inside VBA code. the problem is that my query is a select query and therefore I can't use RunSQL :( I tried to work around it withbut had no luck... this is the code: strSql = "SELECT '" & Me.number & "' ,Karin.[subject] " & "From Karin " & "WHERE '" &...

hi, I'm using access 2010. how should I share the access file I created that will be the best way? there are 20 users that need to add/edit/view the data. I read in some places that I need to do share on options and some said that I need to split the file to data and front file. what is the...

I solved the problem. I used the same query on both form by accident! thanks for the help! :)

added the file. the problem is on screen 2 it's reference to form called Choose_project. thanks for your help!

Thats the thing! Nothing on form 1 is referring to 2.... The query on 2 is using the table that in form 1 but that's all...