Search results

I'm waiting on my site to be design but soon as it up i will place the link on my site to.

I'm new to this site and member of VB-world site. I have now started working in Access because of a recent project i bided on. I agree the new site is more professional looking and also gree with spacepro.

That would be great and I agree with you except they are scanning data into the Excel spread sheet from a third party software.

I have table name Employees which has photo as OLE object as one of the many fields. I have 20 thumbnail on a form that are not bound to the table Employees but are the picture of the employees. I also have a larger bound OLE object on the form bound to the table employees photo field. When I...

Thumbnails I have a form that is bound to a employees table that has photo in it. I drag the same picture in the form so the look like thumbnails. I want to click the thumbnail an it fill the Image box with the same picture from the employees table. How

Thumbnails I have a form that is bound to a employees table that has photo in it. I drag the same picture in the form so the look like thumbnails. I want to click the thumbnail an it fill the Image box with the same picture from the employees table. How

I have 20 different Cities across the USA. They gather data in Excel Workbook and then they are gone to transfer the Excel file to the Home office sever via highspeed connection. In Access I have link built to the spreadsheet in the Workbooks. Every Sunday night at 12:00am a macro will open the...

You Can use the controll Default Value and place [Forms]![FormName]![Control Name]

I have a Combo Box on a form that is fill with Rep Number. I also have to text box for Begining Date and Ending Date on the form. After entering the begining and ending date you click on the combo box to enter the Rep number then the combo box run a marcro. The macro open a Query that use the...

I figure it out you have to have a macro to update the table

If you find out the how to solve your problem email me scott_07@swbell.net Please

I have even try place this SQL statement in the combo box change event but is say I hve a Data Mismatch. The dat type for the Rep Number is Number and a in the SQL statemnet is a integer. Dim rst As Recordset Dim strSQL As String Dim a As Integer a = Forms![RepInformation]![RepNumber] Set rst =...

I combo is being populated by a Query and I can see all the Rep number or Rep ID but when I go to click on one of the Rep Number it does not update the bound text box on the form. The combo box is bound to Rep Number in the RepInformation Table either.

I have try everthing to update my form with a combo box. I try setting the Form resource to a Query and Table. I have my Combo box Resource set to a query and it work fine, but when I change it the table does not update to the combo box text. The combo box has the Rep Number in it. The form is...

Never Mind I know what happen now it just telling me how many record each Rep has. I need to add the sale on the report and I'm not sure how to do that.

SQL SELECT DISTINCTROW RepMasterSheet.[Rep Number], Sum(RepMasterSheet.Sale) AS [Sum Of Sale], Count(RepMasterSheet.Sale) AS Total FROM RepMasterSheet GROUP BY RepMasterSheet.[Rep Number];

reply I have a table that has 2 fields "Rep Number" ,"Sale" and added a field in the query call Total where it does a count function on the "Sale" field. I made a select query so I can add up the sale field. The query I made add up the sale field except for the last record. There three record...

I made a select query with a field call sales numeric and add a field in the query cal total to add the sale. It work but it will not add the last record in the output. Why

Is the away to code a link to a Excel Spreadsheet

I want to use Access database on intranet that will join 5 different location across the USA. Can sombody tell me that is possible and how to do it.