Search results

I am probably being dumb but I am stuck on a silly problem, all I want to do is when my form opens its sub form which is set to datasheet is ready to add a new record so you can just type straight off. The sub form record source is a string which works fine, this opens at the first record. My...

I have spend hours trying to work this out and either to thick, rusting or its very hard :) What I want to do is take the result form a sql query in vba and append it to a pre-existing table with the same field names as used in the sql. My SQL query is Srch = built on a form and in this...

I need to make the field name created in the ‘as’ statement in this sql a variable I can call in RS.??? What I have so far: - Srch = Me.Select_field & " as " & F1 When run this reads “[Car List]![Make] as Make” which is correct Set RS = CurrentDb.OpenRecordset("SELECT " & Srch & " FROM [Car...

I have an issue where a database has been packaged using the Access 2007 developer tools and has been installed giving the user a accdr file, the issue is that the original source file the accdb does not exist for some reason and I need to modify this file. The person who created this database...

I have an issue with a Access 2007 runtime installed database, this file works perfectly on most machines except two and even on them it will not if full Access. It uses a connection to SQL server to get its data which works as the database opens and allows interrogation of the tables via...

I have a situation where an Access 97 runtime operating database which was running fine on Windows 2000 and Word 2000 has been moved the Windows XP and Word 2003. Now none of the DDEInitiate commands work, all this code did was open the word doc as read only something the users insist on...

I have been asked if I can place an appointment reminder in a specific calendar within outlook, I have been placing appointments in outlook for years using code like this Dim objOutlook As Outlook.Application Dim objAppt As Outlook.AppointmentItem Dim objRecurPattern As...

This is probably a silly question but its Sunday and my brain hurts lol. I want to get the literal value from a field in code, what I want to do is construct in a memo field a email text with the vba code in so when called in my email module it will act on the code given. E.g. if I type this...

I need to get Access 2007 to read a barcode reader live, as in take the data as it is scanned and put it in a table. I have got it to create the barcodes for me that was easy but getting the data back in is doing my nut in lol. I have a R232 data logger which saves the data to a text file so...

I need to import data from a dbase file and during the import I need to check that the postcodes are in the correct format, we have postcodes like ST15OTJ when they should be ST15 0TJ also we will have ST10TJ when they should be ST1 0TJ. Does anyone have any code or clues on how to check these...

Hi All I am looking to find some code that I can use in a batch file to compact an Access 2000 database that has a database password set on it. I know about "C:\WIP\SPOC\OneCall_BE.mdb" /compact but need to find a way to pass it the password. What it does at the moment is open and waits for...

I have an issue with a 2000 database running under 2007. It works perfectly in 2000 and uses code I have used many times and at one point worked under 2007 but all of a sudden it won’t. It stops at Set wb_obj = xl_obj.workbooks.Add(Application.CurrentProject.Path &...

I am trying to open another form from a double click on a combo box and it won’t work, I have done this before without problem but for some reason it won’t play. It’s giving me a headache, Help. Dim stDocName As String Dim stLinkCriteria As String stDocName = "Assets"...

I expect there is an easy answer to this I have a form with a sub form which is a datasheet containing criteria to use to open another form, easy stuff double click on the first field and then the next form opens filtered to that criteria no problem there. The form with the datasheet has an...

Hi All I need to calculate the period between two Now() dates, fine one from the other and subtract the weekends (business days) but I need to show the result in Days, hours, minutes and the current answer is in metric i.e. 5.72. How can I convert this to normal time? Cheers.

Hi Anyone out there have some code to convert a access now() field to a unix timestamp? Cheers.

I got a problem with a date field, in the table it is fine showing ‘04/10/2007’ and the form the same but when I call this field from my code I get ‘30/12/1899’ I’ve looked through the forum and tried the suggestions found and no good. The table field settings are Format = Short Date...

I have a problem with sending a report as HTML via Outlook 2003, or to be correct two problems. 1. With memo fields it is not taking all the text, it is not grouped so it is getting past the 255 chrs. 2. If the report goes to two or more pages then it puts a First, Previous, Next, Last...

I have been using this sort of code to populate Word with great success Dim objWord As Word.Application Dim wrdDoc As Word.Document Dim strPath As String strPath = tempath Set objWord = New Word.Application With objWord .Visible = False .WindowState = wdWindowStateMinimize End With Set wrdDoc...

I found a nice piece of Code in the forum to send data to word and populate form fields rather than using mail merging with an exported text file. It works great but the problem I have is Word stays open after the job is complete. I have told it to save as the finished document which it does and...