Search results

Insert > Object Select "create from file" Hit Browse, select your file and your done. Only issue is it will only display 1 page.

not sure about "filecopy" but you could try putting it in single quotes: FileCopy "'" & sSource & sFile1 & "'", "'" & sDestination & sFile1 & "'"

in code you could just count the YESes... dim i as integer private function BoxCount(Box as boolean) if box = true then i = i + 1 else i = i -1 end if msgbox "You have " & i & " 'YES' count" Stick that to execute on every box "on click" event like so: BoxCount(me.<name of your box>)

The only other way would be to import contacts to db, look for duplicates then exclude them from your export.

Yep, RecordSource = total records shown Filter = some of the total records shown When you change the recordsource to include a where clause it is very hard (or impossible) for the end user to see the entire source. When you change the filter, all the user has to do is switch it off to see...

Try DateDiff("date format", date1, date2) e.g. VB code dim test as string test = DateDiff("h", #11/12/2007 12:00:00 PM#, Now()) or Query builder Test: DateDiff("h", #11/12/2007 12:00:00 PM#, Now()) or SQL DateDiff("h", #11/12/2007 12:00:00 PM#, Now()) AS Test would return the time...

thanks, that did the trick

Thats my problem. I dont know how to do that. visible = false doesent seem to work

If it is a single form then it is pretty easy. Just convert cm into pixils and change the bar length based on % complete. I found that on my setup 10cm = 5670 pixiles. So if you treat 5670 as 100%. Then convert your sheduled days to 100% (1 year = 100) Then you need to do some playing with...

I would suggest that you go through some online totorials for access 2007. You can find some here: http://office.microsoft.com/en-us/training/CR101582831033.aspx There is also specific help for 2007 queries here: http://office.microsoft.com/en-us/access/CH100645771033.aspx In particular you...

So you need to import data from Excel into Access and you have a different format excel file every time, what about your access? Is that also different or does it stay the same? are there common field names between the 2? Is it just the names that are different or are the columns in a different...

"me!listbox.selected(0)" looks a bit wrong. Index starts at 1 and it should be me.listbox.selected(1) = true or just listbox.selected You only need to use ! when you are not coding in the form the listbox is located in. Other than that me.listbox.selected(1) = true should select the first...

A recordset cannot be NULL. It will either have records or not. What you could do is check if a "field" within a recordset is null. If isnull(rs!Fieldname) then msgbox "This recordset is null" end if

Hi, I'm trying to write in some events that I want to start on application open and close. So far I have not been able to find those event handlers. Open is pretty easy, just need to stick it on the first form that opens, but close is a bit tricky. There is no way to be 100% sure that any 1...

I already gave up and removed 2007... It's a continuous subform. There was no reason for it not to work, when opened alone it worked and it works in 2003.

Hi, I'm trying to make my access applications compatible with 2007 and have hit multiple issues, one of which i cant seem to get around! One of my forms has a tab control and one of the tabs has a continuos subform. The problem is the continuos property does not work in 2007!! Any ideas as...

Figured out how it works, thanks for your help! Here is the code: Option Compare Database Option Explicit 'Code needed to use the Windows "Open File" and "Save As" Dialog Boxes 'to capture file path for exporting spreadsheets, etc. 'Declare needed functions Private Declare Function...

Thanks, Unfortunately some of the code doesent seem to work: Global Const ahtOFN_READONLY = &H1 Global Const ahtOFN_OVERWRITEPROMPT = &H2 Global Const ahtOFN_HIDEREADONLY = &H4 Global Const ahtOFN_NOCHANGEDIR = &H8 Global Const ahtOFN_SHOWHELP = &H10 ' You won't use these. 'Global Const...

Hi, I am trying to build a small UI to allow a user to import text files. Unfortunately I have no way to let the user select the file without using Activex controls (which are currently not installed). Is there anything I can do to develop some sort of a basic file-picking UI that returs the...