Search results for query: *

So I have this ID being an autonumber field going up to 25000 right now. Now I need to add a table entry with a specific ID like 50000. How can I accomplish this? Once I convert the autonumber to a regular number and add the entry I am not allowed to turn it back to autonumber (but need that...

I just want to change a sub-reports link to the parent report... but I can't find properties similar to linkchildfields/linkmasterfields as in forms... anybody an idea?

I am formatting table entries into a reports detail section where the entry can either be a header or some detailed data. Now I would like to create a page break inside the format-event similar to word. "If the header is the last thing on the report and the details wouldnt fit onto the...

For those who were following my miserable quest on why access 2002 form crashes for no obvious reason (thank you for all the tips already), I have a new theory. By removing some related code, so far I had no crashes any more. However this code is essential for me to display data in a sub form...

I have some extreme problems with a function inside a form that updates some of the displayed elements. The code ist here: http://www.midiport.de/problem.htm Has anybody a clue whats the problem here? Access crashes big big time with the code! (Not even an Error Message). I appreciate any...

Has anybody expierenced similar problems? When I change the controlsource property of any form field in VBA, Access crashes big time!!! (Problems with the "oleaut32.dll") Anybody?

Does anyone know of a software tool, that allows editing users and their passwords in the mdw? I am programming a dbi-web interface so the users can NOT access any access-internal functions (like password change, etc.); but the administrator MUST be able to view and change these settings...

Another interesting problem: If have a table containing text entries with a category and a position number, like this: [intPosition] [intCategory] [intText] 1 CAT1 Text1 2 CAT1 Text2 3 CAT1 Text3 4 CAT2 Text4 5 CAT2 Text5 6 CAT2 Text6 7 CAT3 Text7 ... and so on...

I have a continous form with several checkboxes, each of them has a "formula", that returns True or False: ControlSource=myFunction('blabla') Now the user is not able to EDIT this checkbox anymore... it seems to be kind of 'locked'... Does anybody have an idea/approach to this...

I am saving several bit-flags in a Byte field which I am using in a continous form to fill some checkboxes (Value 1 = Checkbox 1, Value 2 = Checkbox 2, Value 3 = Checkbox 1 + 2, etc.). Now I am trying to find a way to to parse this byte by bit-comparison inside the recordsource property of the...

A couple of msoComboLabels (populated using .AddItem()) in my CommandBar are supposed to *remember* the values the user has chosen, so the next time he/she encounters that ComboBox already displays the last choice. This is no problem as long as I am working with a fixed number of items. Saving...

Hm, still working on the problem... later in the program I try to loop through a range that depends on the last entry-row of locPort.column (most of the times Column B). The following llop returns no row at all though there is content in the cells (and it worked some time before. My assumption...

I am looking for a way to delete all cells and all content from a specific row on to the end of the sheet... Does anyone knoe how to accomplish this? I appreciate any hint.... (This loop cycles through all rows of a certain sheet and is looking for the string "delete ever.....&quot...

Hi! I am using this function to open the standard browse-folder dialog... Does anyone know how I can set a default directory in which the browsing starts? Thanks in advance waldemar Function findFolder() As String Dim shellapplication As Object Dim folder As Object...

A new Challenge...: Has anybody had expierence accessing an A2kc MDB Database (running on nt server) through PERL (running on apache)? Where is a good place for me to start with this?

I have sort a join Problem between two tables. The difference to regular joins is that I dont want to join the rows, but two or three field entries... Two Tables: Table A contains fields (not rows) listing intCodeIDx, intCodeIDy, intCodeIDz. Table B holds a detailed field for each of these...

Ok this is the last one I promise :) I am trying to locate COLUMNS by finding their Column Headers more specific their Text: Function findLoc(strIntelliText As String, rng As Range) As Range Dim rngResult As Range Set rngResult = rng.Find(strIntelliText) If rngResult Is Nothing Then...

I am trying to find specific formulas in an Excel workbook. Cycling through all the cells of all the sheets wouldnt make any sense (too long). I found something like a Formula "Array" in the Range Object (I'm using the UsedRange for all references), that seems to list all formulas in...

I am automating Excel via Access, just reading out some data. I don't want the user to do any interaction while this is happening. However I get warnings (Unklinked references, DO you want to save changes, etc.) which I'd like to turn off. ExcepApplication.DisplayAlerts False (right after...

I opened an Excel File like this: Dim Excel As Object Set Excel = CreateObject("Excel.application") Excel.workbooks.Open (strFilename) Now, I', looking for a way to access speific cells in the way "Sheet!A1" or "Sheet!A1:B2" Through the Cells...