Search results

Hi littlepeaches68, Where are you storing your front end? On the server as well? Or locally? If the databases get to big it could be a network bandwidth issue. Look forward to your reply. Robert88

Hi JReichnan, I have performed a default combo box to update a table, not a date but it should work for dates as well. http://www.access-programmers.co.uk/forums/showthread.php?t=103048 Hope it helps, felt like I was having a convesation with myself in the link.:p Robert88

Hi GHudson, Very informative, so much for Microsoft's security :eek: I think you have just found a hole so big, I wonder if Microsoft knows? Bet they do not even want to know? Since they do not support 98 anymore. Got an old Windows 98 machine at home, going to try it with some of my...

Hi Try this link, code is at the bottom, not sure if it will help. http://www.access-programmers.co.uk/forums/showthread.php?t=92658 I was reading files into a table, would that make it easier? Hope it helps :eek: Robert88

Hi KMaples, Do not know anything about Brio but I am assuming you could look to export to a txt or CSV files form Brio? If this is the case Acess can read these types of files. Hope it helps. :p Robert88

Hi tom8249 Attached is a search form with dates, I hope it helps. Robert88

Hi Shinyo21, Can you be a little more precise, a field in a table or on the form? :rolleyes: If it is form field to table field check this link; http://www.access-programmers.co.uk/forums/showthread.php?t=102707 Robert88

Hi dlusion, Check this thread; http://www.access-programmers.co.uk/forums/showthread.php?t=96996 I suppose just create an import spec with only the fields you want to transfer. Hope it helps. Robert88:p

Hi Hubba, Sounds like cascading combo boxes. Try this connection; http://www.fontstuff.com/access/acctut10.htm Robert88

Hi Monty create your query with all your fields. In the field "Msgno" field for the criteria place "NOT 1403", this should give you the records you want. If you want to delete them look up the site for a delete query, good luck. Hope it works, late here in Melbourne, good night. Some have...

Hi mjpzx2, For your first issue I would check the IIF() function. For your second issue check append query's in order to move the data to another table. It is now bed time for me now, good night.....:p You can also use the search facilities on this site, it has plenty of examples. Good...

Hi mjpzx2 Check the function, now(). Hope it helps.:p Robert88

Hi Kellmet, Not sure if you can get your hands on a magazine I have subscription? The article is written by Doug Steele, titled: "Connect Your Split Application", document #17454 from the magazine "Advisor Guide to Microsoft Access" on page 36. If you had subscription it is located at...

Hi nrmarthi, This is a good one, even I need help...... ;) I have created a table tblCalculate, query qryCalculate and form frmCalculate in the attached zip Calculate. On the form I have created a button CmdSum which I was hoping to show you both unbound and bound additions, but even I have...

Hi nrmarthi What are you not exactly sure of? Robert88

Hi Ankie, Yes you can use more than one query, I suppose it depends on how much information you have to display and how much screen space you have. Robert88

Hi Try this code; Private Sub Form_Template_Click() Dim frm As Form 'Create a new form based on the XXXXX form Set frm = CreateForm(, "existing_form") DoCmd.Restore 'Set RecordSource property to inputQuery query frm.RecordSource = "inputQuery" End Sub I...

Hi Steve711, Is it possible to reveal the code under the SAVE button? Robert88

Hi nrmarthi, I suppose you just have to change this form's calculated field to bound and you've got it. Good luck Robert88

Hi maacky99, Sounds like Cascading Combo boxes to me? Check this link; http://www.fontstuff.com/access/acctut10.htm Robert88