Search results

Hi davidg47, I suppose it is hard to post all when the database is too large. If this is the case as I sometimes do, reduce the data in the tables and run "compact and repair" before zipping it. Will understand if data is sensitive as I am sometime in that situation. If this is the case I...

Hi moto, I suppose once all tables have been imported, any relationships amongst tables have to be re-established. Good Luck with it.:p Robert88

Hi Kelemit, Interesting problem one currently I am not able to find a solution. I suppose you would also have to consider if the same name file is on the new destination server as well, not likely to happen but is possible.:eek: Robert88

Hi davidg47, Possible to paste an example of the database in order to see this? Robert88

Hi Amavdia, Just thinking out a loud, maybe include a field yes/no (say no as default) in the fields amongst your subform. In order to select your subform customer then switch your default "no" to "yes" maybe using a box to tick. I suppose with a little SQL select the "yes" field, giving you...

Hi Moto, If you have linked tables in your access, this provides a link directly to the SQL table, so any changes via editing in your Access application will then directly change the data in the SQL tables. To check to see if they are linked goto tables tab in your mdb and if there is an arrow...

Hi All, Does anyone here know how ot access the "Group Memebership" of your profile? Robert88

Hi fulltime, normally when I see these types of errors with Internet Explorer I use the System File Checker sfc.exe. You will need your Windows CD. Execute; at your command prompt. This conducts a system file check and updates any that require updating. here are some links for notes on it...

Hi Kiwigirl007, I hope I have this correct, but I think this is the only code required. Private Sub LOC_Click() On Error GoTo Err_ConfirmationLetter_Click DoCmd.OpenReport "ConfirmationLetter", acPreview, , "[RegistrationID]=" & Forms![Attendees]![Attendees Subform].Form![RegistrationID]...

Hi GHudson, Thanks for that response. Robert88

Hi mjohnson629, Check this code or take a look at the attached as well; Private Sub CmdCleartblDetails_Click() 'Delete tblDetails properties Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue with deleting all records in tblDetails ?" ' Define...

Hi Mat, I am still awake here in Australia as currently it is 2:08 am. :eek: I have code at work which will tie together the code from the link below to delete the information with your yes/no button. http://www.access-programmers.co.uk/forums/showthread.php?t=104959&highlight=Robert88 You...

Hi Sam Summers, Is there any code on open event of the form you are opening? Another question, are the fields bound or unbound? If bound, what are they bound to? If a query, maybe a query has been changed which resulted in a new record shown which was blank and now you are seeing the first...

Hi ghudson, More so from an interest point of view what actually happens when you use reserved words? Have you had any exprience with using them and what actually occurs when they are used or maybe what does not occur?:rolleyes: Robert88

Hi usfscoop, Attached is a table, tblValues and query, qryValueTable and form frmSumValue1SumValue2 which includes Value1, Value2 & Value3. As indicated by MStCyr, it is not a good idea to store calculated values. The form contains a query which within it are the calulated values as seen on...

Hi usfscoop, Doh! I made a form with button which calculates the third field attached, but it is not what you want. Be back soon with a better sample. Robert88

Hi Kelemit Is this neccessary? If you map a network drive to a share (say Z:\) and you have to move servers then disable the shared folder and renable the same share name on the new server. Using scripting for individual users or maybe even a group you can re-map thier new server and share...

Hi a2knovice, Code on_click event; Private Sub CmdAppendQuery_Click() On Error GoTo Err_CmdAppendQuery_Click Dim stDocName As String stDocName = "qryAppendQuery" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_CmdAppendQuery_Click: Exit Sub Err_CmdAppendQuery_Click...

Hi MsLady, You are right about talking to myself, but since I am doing so much learning I am pretty much pasting what I learn, in this case I eventually got to the solution, but always living in hope that someone will paste the solution like in Option_Group_Final.zip file at the end of the...

Glad to help........... Hi fulltime, Glad to be of help!!!! :D Another method to perform this action is to create a special macro named "Autoexec", within it place the form name to open and this will do the same trick upon opening your db, in fact what ever is placed in this macro will...