Search results for query: *

Yep great PHV, that was what I was looking for. Also thanks to the others for their input. Pampers [afro] Keeping it simple can be complicated

Hi everyone, Looking for a query that select the following: id date number 1 12-11-2011 3 2 12-11-2011 5 from this dataset: id date number 1 11-11-2011 2 1 12-11-2011 3 2 11-11-2011 4 2 12-11-2011 5 ... Can't figure it out Regards Peter. Pampers [afro] Keeping it simple can be complicated

hi wesmamas, well i think i understand the problem, atleast i hope... why dont u open the report from the form where u ask the users input? Pampers [afro] Keeping it simple can be complicated

I am not sure that is possible....Just redesign it in ms access. Pampers [afro] Keeping it simple can be complicated

Hi wesmamas, I think you can use the same query as the recordsource of your report, with the same reference to the form... Pampers [afro] Keeping it simple can be complicated

He Greg, No worries, you are idea was clear. After i posted my reply, i aslo thought, does it matter that the extension is taken off... Pampers [afro] Keeping it simple can be complicated

Thnanks for the reply, but that will take out the point of the file extension as well i believe.... Pampers [afro] Keeping it simple can be complicated

I mean, I will take out any point in the filename and use FileCopy to import the file Pampers [afro] Keeping it simple can be complicated

Well, I agree that the points in the filename is bad practice, but if that is the file name you get to work with, that is the way it is. Furthermore, Windows allows you to use these kind of names in the first place, so one can argue that the transfertext would be able to work with that as well...

Hi everybody, I am trying to read a file into a table using transfertext command. But if the file name holds '.' before the file extension, Access cannot the find the file (error 3011). My code is: DoCmd.TransferText acImportDelim, "specArtImp_SchapKaart", "tblArtImpLocalTemp"...

Is the database not automatically compacting on closing of the front end? It is a 2007 setting. Pampers [afro] Keeping it simple can be complicated

Hi Everyone, I created a little help-system through microsofts 'html help workshop', that produces a chm-file. You can hook this file up with an Ms Access application through f.e. the forms HelpFile-property (path to the file) and the HelpContextID-property (points to a specific topic within the...

Hi jmeckley, Thanks for the reply. I think I am aware is a difference between the framework and js. What i want to accomplish is that on the loading of a webpage some js is executed. I was trying to add some js in the .aspx form. Didnt succeed. Then I added some code in my code-behind page and...

Thanks Vacunita for the reply, I dont think there is a body-tag since it has a master-page, so it holds content-tags... Pampers [afro] Keeping it simple can be complicated

Hi everyone, I have webpage (apartmentdetail.aspx) with a site.master (asp.net). After the page (with a formview for databinding) loads I want some js to be executed. It will set an html-image source (src) to that of the first loaded image. Here is the code for the controls. <img...

Hi jmeckley, Thanks a lot for your reply and answers. First solution works fine. Second one doesnt work. Pampers [afro] Keeping it simple can be complicated

Hi everyone, I wrote some JS. I have an asp-imagebutton (within a formview)and js-function. On mouseover of the button the function will be called and it will get the src from the imagebutton. All works ok. But how could I pass the control dynamically into the function and then take its src...

Mmm, it always funny after one posts a problem, one gets more inventive and figure it out. Just give up table name that doesn't exist yet, and access creates it... Pampers [afro] Keeping it simple can be complicated

Hi everyone, In Access (2007) you have the option to import an excel sheet into a new table manually (with a wizard). How can you automate this process? I can not append the sheet to an existing table since the sheet various in format (more or less columns with different column headers) Pampers...

Hi ca8msm, I thought i tried putting "http://" in the datasource before. Ha. But this time around it worked. I added to the query, and it works fine. Thanks a lot for the answers and swift reply. Pampers [afro] Keeping it simple can be complicated