Search results

Hi, I've reports that when I do preview & all the sort would display the images but once I print it no pictures prints out. Please help. Thank you.

Hi, How do I query using this format ("lastname,firstname")? thanks

Hi All, I've 3 tables that I want to query, I want the data to display on a form? How do I do this? My form is a continous form. Help. Thank you in advance. :)

Hi, Happy New year to all! Thanks so much for all the help I get from this forum. Again I'm back to ask questions :) Here goes.... First I have a Main form where I want to put 2(two) subforms, I want to relate the 1st form to the main form and the 3rd form to the 2nd form the catch is I...

Hi, I've been trying to create a cascading combo which has 3 combo boxes but I am getting nowhere. Can somebody help me please. The form "frmCommunicationInfo" has Category, Make and Model which is a combo box that I would like to display the data on the first combo box which would relate to...

Hello, I have 2 forms, both are data entry forms only a few minor difference. What I want is to have the data on the 1st form display on the 2nd form (not necessarily all the data). The 2nd form is opened once I click on a button. When it is clicked I would like to display the current...

How do I make my form follow the size I want? It's in access 2007

I created an exit button. I want to close everything (database, forms, query, macro). But the codes I put in it just doesn't work. How do I do this? thank you.

Hello, I have a form where i get to insert files (images, doc, pdf, excel, ppt files). I am able to load it to the form and display it. Right now it displays the whole path of the file. My question is... Is there a way to save the path but not specific to the drive just the folder where it is...

Hello, I have a form with a combo box on it. this combo box displays different location. If a location is chosen I need to call a report and display the particulars. Can somebody help me please. I already made the form and combo box and the report it's just that I don't know the code to make it...

Hello everyone, This forum has helped me a lot and still continuing.... I have an add form wherein I have 3 buttons (floor plan, lease Contract and building photo). What I want to know is how do I add this to my database so that when a user view this they just click the buttons and the files...

I would like to create a form wherein I will have a map of a vicinity and once a certain location is click I would be able to display information. Any ideas would be greatly appreciated. Thank you in advance.

Hello, Can somebody show me(i honestly don't know how to code this) on how to set the bacground color of the details section of the form depending on the date. For example If date entered is 05/05/09 - say this date is today the color of the details section pertaining to the records should...

I have a table which I want to have a particular field be presented as graph (Pie chart). In this field I have 8 different values which I want to count and present the total of each in a graph. I honestly don't know how to do this. can sombody help me please?

I've a form with query as my record source. When my form opens I would like to be able to click on any fields and another form would open having all the data of the particular row of data displayed. Right now what access is showing me when I do this is just an empty form where I am suppose to...

I've a cascading combo box that when I choose the first box I get a message runtime error '-2147352567(80020009)' You tried to assign the Null value to a variable that is not a Variant data type. I use query as a record source. Any Idea?

I've a database that when opened would display any work that is pending or in progress. what I want to do is when the user click any record it will open a new form and go to that specific record.

I've got this code, once it updates it would give me a run-time erro '13' type mismatch date_completed is a date Here is the code: Private Sub cboStatusId_AfterUpdate() If cboStatusId.Value = 1 Then Me.txtDateCompleted.Visible = True Me.txtDateCompleted = Now(date_completed) Else...

I tried querying all my tables (9) on 1 query why won't it display any record? There is already data on it.

Hello, I've two combo box. Lets call combobox1 and combobox2. when you add and choose data from the combo boxes and will save it and it will display the data but once you add another data it will only display the data on combobox1 and the present data on combobox2 and if you go back to the...