Search results

Afternoon all, long time member but very infrequent visitor in recent years. I used to do a fair amount with Access/VBA, but haven't really got my hands very dirty for about 10 years. I now need to take a couple of applications using Access front end (Access 2003 I think) and a SQL Server 2008...

Hi On several occasions my work PC has been turned off when I arrive in the morning. I've checked the Event ID 41 and can see that powerbuttontimestamp has a value <>0, which suggests someone has manually switched it off by holding the power button. Does anyone know how to convert the timestamp...

Hi all I'm trying to open an Excel file from within Access, then save the file back as a csv. I'm currently using the following code... Private Sub RunExcel() Dim xlApp, xlBook As Object Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add("X:\MyWorkbook.xls")...

I'm trying to replace all the dates in my workbook in a specific date format with a different format using the following code... With Application .FindFormat.NumberFormat = "dd-mmm-yyyy" .ReplaceFormat.NumberFormat = "mm/dd/yyyy" End With Cells.Replace What:="-", Replacement:="-"...

I apologise if this question has been answered elsewhere but I have tried looking and can't find anything that helps. I'm in the process of upsizing an access database to an adp front end and a sql server back end. One of the forms in my original database was a continuous form with some...

I'm writing a sql query in an adp where a few of the columns are calculated using CASE statements. e.g. SELECT columnA, columnB, CASE WHEN columnC IS NULL THEN 1 ELSE 0 END BooleanColumnC, columnD GROUP BY ...... HAVING columnA = @parameter1, BooleanColumnC = @parameter2 When I try this though...

I have a PS2 and my brother is bringing his over at Christmas. Does anyone know if i can connect the two directly to each other using a crossover network cable? From what I've read you can play games over a network with a router but does the same apply to just connecting the two directly to each...

I've got a form based on a query. Is there a way I can filter the records showing on the form, based on the records in another form's recordset. I've managed to get the second form to show the same records as the first using me.recordset = forms!otherform.recordset but I actually want some...

I have a continuous form based on a query with the criteria as all records where a certain field is null. From this form, the user can fill in values for the null field. I then want to click a button on the first form to open another continuous form showing the same records so the user can go on...

I recently got asked by a friend to set up a database for him to store his business contacts (so he can do mailshots etc) along with some basic order history. I've come up with the basics of this database (attached). There is still some work to do on it, a bit of tidying up and some reports etc...

One of my database users set up a new record a few days ago, entered all the information etc. He's now gone to have a look at it and it appears to have been translated into Chinese or something! The text fields have changed to things similar to 潩の＀ㇾ′敆湲慤敬, the autonumber field has changed to...

We are shortly going to start using tablet PCs over a GPRS bearer circuit for some of our employees to update our core business system from within customers homes. To do this we have purchased a very streamlined version of our core system, designed to work at a reasonable speed even over a...

We use two different systems in our office that have notebook facilities. One of them stores only a limited number of characters in the note field per record and as such, some notes actually span several records. The other system stores the whole note in one record. We want to transfer all the...

I am creating a membership database at the moment. When I create a new member, I put the start date and expiry date of their membership. I want the start date to always be the first of a month, but I need it to be the closest first of the month. i.e. If I set up a member on 05 May, I want the...

I'm building a database to record membership details. I have one table for people, each with a unique person ID as the PK. I have another table which records the membership periods. These will generally run for 1 year. The membership periods table has the person ID, a membership period id...

I'm using docmd.transferspreadsheet to import data from a spreadsheet into my database. I need to check that the spreadsheet being imported hasn't got an autofilter on it though, before it is imported. Is it possible to do this from access? I know in Excel it is possible to check using vba but I...

I have a form (Form1) with two combo boxes (Combo1 and Combo2). Both have their Row Sources as queries based on the same reference table (tbl1). For ease, I'll say the table has two columns as below. Col1 Col2 1 A 2 B 3 B 4 A 5 B The first combo box has a row...

I've got a temporary table which I'm using as the source for a mail merge. I need to either delete the table when it is no longer being used for the mail merge or be able to test to see if it is being used at that moment. Can anyone point me in the right direction?

I've got a mail merge document set up, but whenever I open it, it calls a new instance of my database. I know this is a common problem when you set a different database title, but I haven't done that. I still have that blank and the title showing in the title bar of my database is 'Microsoft...

I have a form set up with various date fields and I have set up a form with a calender to fill one of the date fields on my main form. I am opening the calender form by doube clicking on the text box. I am using a command button on my calender form with Forms![Rec_Customer]![Date1] =...