Search results for query: *

I have over the years built my own database and learned alot for the good people of this forum. One of my computers died so i bought a new one and loaded MS office 2010 to get up to date. Now my problem is my DB was created in Access 2003 is there a way to transfer it accross or should i start...

Is there a way to have a customer record dispalyed on the screen click a button which scans a document on a scanner and saves it tagging it to a specific customer.

I have built my db with help from this forum into something that works well, now i want to progress it and have a webpage on a server that i log in to and query my customers table then send that full record back to my PDA. Is this something that could be done secure? And as i know idea what...

I have a table that contains customer info, site address etc the problem is the site address is sometimes different than the invoicing address, so i have created some more fields, inv_add etc. How do i get the report the check if there is data in the inv_add and use this instaed of the site_add...

Hi I have a panel that sends a SMS message via a the GSM providers, i want to try and capture the data it sends so i can see how the format and strings are made up, anybody have an idea on how to capture this data. Thanks

Hi Can somebody point me in the right direction, want to be able to query my db over the internet via a secure page on my website, select and send customer info to my PDA , not got a clue what i need to be reading up on or where to start this new learning curve. DB is access 2003

Hi All of a sudden my DB is displaying a Visual Basic error 2004 out of memory when i open a report, i cant even open the report is design mode get the same error, but everything else and all other reports work fine.

I have a database that i have created over the years with help from here, now i have been playing around with Access 2007 and like the attachements and the way you can add attachements to a record. Is is striaght froward to use a db created in access 2003 in access 2007 or are there some...

Using the date picker on a form, i have tried various ways of geeting it display the current date, but itstead in reverts back to the date in the properties box. Is there a way to get it to display the current date. Tried to get the form on open to set the date via dt2picker.value=date() But...

Could somebody have a look at the below code, can only get the code to email one customer, also is thee a way of forcing outlook to use a email address that you specify instead of grabbing the default sending address. Private Sub Email_Click() Dim db As Database Dim rs As DAO.Recordset Dim...

I think i may have done wrong setting up my db but its to late to change, i have 4 fields (text) service month 1 to 4, with the month in a drop down list as text, eg November. i have been trying to query these fields with date(m)) so i could set up a automated query to run on the 1st of the...

Been looking for some starting points, i have seen a application on a db that has a secure web page with three fields on it (system ID, Telephone No, Postcode)a remote engineer fills these in, once sent back to a db it then sends him all the information on the site he is at. Has anybody done...

Iam realy new at website's due to being forced in to creating my own after various attempts to get a Co to do it. Iam learnt loads at the moment and finding really intresting, and enjoying it, (do i have a mental problem all these late hours ?) I have signed up for google webmaster tools etc...

I have a query that uses the following to sort records >=DateAdd("d",-21,Date()) This lists all records that have a renewal date within the next 21days, this works fine but it brings up records that are previous than todays date, is there a way to stop it bringing up the records before todays date.

Is there a way to output the results from a query to a XML file automatic. Thanks

Having a problem getting access to outlook, the problems starts with a broken reference or project, which iam unsure about. Set objOutlook = CreateObject("Outlook.Application") Set objAppt = objOutlook.CreateItem(olAppointmentItem) The problem is with the olAppointentItem which seams to cause...

I have a button on a form that when pressed prints a report for the customer only, i have been trying to find a way to get the button to update a table that it has been pressed and record some information. When button pressed it does the following: Run the report (works) Update tblhistory...

I have move a db on to another pc which has access running another db, i have had this working before but since moving it to another pc one of the access applications runs fine but any other is coming up with a error "couldn't find system.mdw, this file is required for startup" Any ideas

Iam trying to setup a order database to keep track of my stock, so far i have got all the relevant information in, now what i cant seam to be able to do is, i have a form that has a sub form on it that lists all the equipment we use and this is where i want to pick equipment from, now is there a...

I have the following code on a button which runs a report, is it possible for this button to run two reports so if a field equals A it prints report 1 if the same field equals b in prints report 2, iam lookin in right direction or should i be looking at queries. Private Sub...