Search results

Can somebody give an excel newbie some tips how to work structured and organized because I am making a tool for my company and it's lookin' more and more like a spaghetty-bord. I am used to program in access where everything seems so organized, now I make calculation in different places of my...

I want to import data from Word docs into Access. Each word doc is created from a template. So each doc has the same layout. I searched this forum and found a way to import data with the bookmark property. This works perfectly when I add the bookmarks after the doc is created. But when I create...

I need some advice on this, here is the situation: I got 2 listboxes where only 1 can be shown. I got to ask 2 questions to the user: 2 sided? -> NO ==> Show lisbox 1 -> YES -> Specific combination? -> NO ==> Show listbox 1 | YES -> Show listbox 2 How should I implement this? I was thinking...

Hi, I am making a simple searchform for my moviecollection, I thought by selecting an item in the resultlistbox, I'd show all the relevant info of the selected movie in the ControlTipText property of the listbox. But ms access tells me my value is too long. Isn't there a simple alternative...

Form toolbar I have to adapt an old excel file. The person who made the file, used objects from the FORM toolbar on the worksheets. How can I access these objects within the code so that I can change the properties. I can't see the controls in the dropdown list after 'me.' Someone? :(

I used a function to get around this. Function USdate(EURODate As Date) As String Dim month, day, year As Integer day = DatePart("d", EURODate) month = DatePart("m", EURODate) year = DatePart("yyyy", EURODate) USdate = month & "/" & day & "/" & year End Function

Omg, i feel so stupid. Sorry for wasting your time KH :ashamed:

Can I capture the close form event that occurs when the user clicks the "X" button at the top right of the form instead of placing a self made button and coding the click event. I don't wanna be a pain in your ass but my form is already to crowded with buttons and other objects that there is no...

Thanx for the replies all, you're all so helpfull. What a service the users get over here :p This did the trick. It was so damn easy :) @ KenHigg,I think I'll follow your advice because the autonumber serves as a reference number the client will use to refer to an Assignment they filled in...

How can I tell Access to restart the autonummering if my table is empty. The autonummering field is the primary key of the table. I guess you now are all wondering why the hell I want Access to restart the nummering... Well, it's just an informing question because the users can see the...

omg, thanx. This was the thing I was looking for. Nothing found in the help about the iif() function. Didn't know where to begin my search. THANX A MILLION dude! :)

Hey, I don't know if it can be done but I'll ask my question anyway :) I have a form with a listbox that is bound to a table "Assignment". So the listbox contains all the Assignment-records. The table "Assignement" has a yes/no field "Completed". This has to be a yes/no field because this was...

No, the thing is: stSQL already exists. stSQL= rowsource of my listbox. What you are doing now is initialising stSQL but in my case it already has a value. I'll explain my situation a little more. My form consists of 1 listbox and 2 frames that each contains 3 radio buttons where only one can...

yea, forgot to mention that :)

I have several checkboxes where only 1 can be checked, every time a checkbox has been checked, I want update the rowsource of my listbox. So i get the SQL string and update the string with the new condition. Can it be done like this: stSQL= "SELECT field1, field2 FROM tbl1 WHERE field1='test'...

thanx, you helped me alot. Didn't know ya could use vba function in the query design. I used: Aanvraag: FormatDateTime([Datum];2) thanx again :)

Hey, I have a date/time field in my 'Assignment' table. (ex. 5/06/2004 11:32:45). Now I made a query based on this table that has to format the date into 5/06/2004. It has to be done at this level and not after I pulled out the data from the database because the data goes straight into my...

People always remember if you keep repeating ;)

Maybe ya can find somethin' usefull in my thread from a couple weeks ago: http://www.access-programmers.co.uk/forums/showthread.php?t=68523

thanx for da replies but I solved the problem myself :): Dim stImageName As String stImageName = Me.OpenArgs 'Initialize ImageFrame Me.ImageFrame.Picture = PublicFunction.getImagePath() & stImageName Me.ImageFrame.Height = Me.ImageFrame.ImageHeight...