Search results

That picture I included was only to demonstrate the dialog box that is popping up for clarification. It is not saving 2 new queries. I created those queries in a different database in order to get you a screen shot to show what dialog box is showing up. Within the accdr the dialog box asks to...

Thanks for the attention bob and dfenton, I'm certain that there are no querydefs being used. In another section of I make use of Tabledefs, but my problem is that the form design is changing, not data. If I was able to upload a front end I would but that's not something I'm allowed to do...

mcd I understand exactly what you are saying. I know exactly where you are going with this. I am attempting to cut you off at the pass and explain that is not what happened. Specifically, I am asking if their are any known bugs or anomalies present in ACC2007 where a file saved under that...

Yes, thank you for the reply. What I'm saying is the changes were made while the file was of the accdr file extension. Only the run time of ACC07 exists on their machines so it's not like they were able to get anything out of changing the extension, if they did.

I finished my post saying you can handle this automatically with the package you are planning to distribute. If you look at the 3rd part of the package wizard you'll see you have the option of adding additional files and below that any registry keys you need to add. You put your registry key...

I use a registry key. The reason why you are getting the warning message is because the database is not in a trusted location This is how I do it: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location5]...

This problem is making my ::boggle:: In two separate locations with different users I have had an issue where they have somehow made changes to their front ends when the front end is saved as an ACCDR. Their computers only have the 07 run time installed. It was my understanding that no changes...

I dig it, thanks man

I've noticed in the past that if I have a button control on a form and have an code like such behind it: Private Sub BtnSaveClose_Click() currentdb.execute "INSERT INTO tblTable.* FROM tblTable.*;" DoCmd.Close frmForm end sub If I double click, or just click fast enough I can fire off...

dfenton thank you for your reply. I was actually hoping to get a response from you on this as I've had to reference posts of yours and your wiki on the subject through this process. Thanks for taking the time.

I've made progress bars in the past and I've sync'd replicas in the past. But something that's always been a problem for me is meshing the two together. With Access 2007 is it possible to create a progress bar for use during: Dim db As DAO.Database On Error GoTo CmdSynchronize_Click_Error...

You can move the window off screen completely, but then anytime your forms open up if they are set to center they will be lined up against the side of the screen the window has been moved off of. Or you can hide the screen, hiding the screen would require you to set all your forms properties to...

The only input I have is that with any product that is imbibed once a corporation gets there hands on it the quality, safety and desirability of it typically goes down in the name of reaching a bottom line where output is through the roof and cost is driven as far down as possible. I think it...

This is definitely an aesthetic question, currently in Access 2007 the default text box uses a blinking "|" as the indicator for where the text will be placed when a user types. Is there a way to change that bar to the old "_" underscore like on a terminal application? I've been playing around...

I'm waiting for the day when someone spills a coffee on themself and sues because it wasn't hot enough to burn them so they could sue.

There are a few devices I consider to be unholy and warped malformations of what they could have been - namely cell phones and the Ipod. To me the cell phone could have been great but it's just exploited and tweaked until the company is siphoning as much money from it's users as possible...

If you are using the activex web browser you can use somestring = Browser.Document.Body.Innertextand that will dump all the text into the variable. if you have multiple results you can loop using lbound and ubound if you fill each of your results into an array. Parsing is easy with xml, it's...

I'm going to venture out and take a stab. You could do something like: Dim lPostCode as Long if Instr(String, "<POSTCODE>") Then lPostCode = Split(String, "<POSTCODE>")(1) lPostCode = Split(lPostCode, "</POSTCODE>")(0) that would pull it out but I imagine it would take a while and...

http://www.aksalser.com:80/game.htm My pop sent me this, it was a good way to waste 15 minutes.

This is a long shot, do you perhaps have Warnings set to false in the coding anywhere? If they are not set back to true then if a query is run and it fails to append records it looks as if it simply doesn't do anything. Try making a blank form, put a button on it and in the code for the button...