Search results

It is a one off transfer and I'd happily do it in Excel as it appears easier. The problem is that there is a limit of ~65000 rows in Excel. Unfortunately I have getting on for 2,000,000 rows to deal with which would mean going through the same process about 30 times. :( If someone can give me...

I think %'s are used instead of *'s as wildcards in SQL, so you may need to replace the %'s with *'s in your query, although I've got a feeling you can tick a reference or change an option to enable you to use %'s but I don't really know. I'm sure someone on this forum will know more.

In your first query just add a parameter to the date field. If you put <=[Date:] in the Criteria box for the 'payment made' date it will prompt for a date when you run the report and only return payments made before or on the date you enter.

No problem. There is quite a lot on this forum about access runtime, and various links to several places where you can find more information (MSKB etc.). Searching for Runtime would be a good place to start if you need any more information as it's likely that your questions may have already been...

You need to run it with the runtime switch. Have a look at Pat's posting here

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...

Search these forums for Access Runtime. You need Access Developer edition to do what you require.

Does it only happen if the two users try within a very short space of time or does it do the same whenever one user has created the table, but not finished using it? I run some mailmerge letters from a temp table created with make table query, but when the user attempts to create the table, I...

DateAdd("ww",6,[First_Date_Field]) Check out the help file for other date intervals you can use i.e yyyy = year, q = quarter etc.

I was just pipped to the post, but by a much better answer. :rolleyes:

You can add the code into what is already there. i.e. below where you have DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 just add Dim str As String str = Forms![frmSubscriptions]![cboPlan] MsgBox str I guess to keep your code tidy you should probably declare your...

Thanks for the suggestions. I figured out a custom function in the end. There's no real reason why I couldn't just test if the date was >15th Colin as that would work generally, I just wanted to round it so that it works accurately even in February. Makes very little practical difference, but...

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...

Another good one I think was suggested last year, was taking a screen print of someones desktop, hiding all their desktop icons and setting the wallpaper to the screen print you've just taken. :D

The other problem I realised as I was typing that is that if you want to return everyone who has completed for example two specific courses out of four, anyone who has completed the two specific courses as well as some others, won't be returned. You may be able to get around that by revising the...

I have quite a messy solution and I'm sure someone will come up with a better solution. You need two queries and an extra field (CourseValue) in tblCourses. tblCourses CourseID - PK CourseName CourseValue tblStaff StaffID - pk Name tblCourseAttend CourseID StaffID The idea is that you...

An update query should do the trick.

OK. I've had a quick look now. Just a couple of questions. Are you using the 2 forms based on queries to input data or view data or both? Is one person ever going to have more than one Career Progression form filled in? Same question for Training Tasks form. My initial thoughts are that you've...

Do you want to mail me the zipped one.