Search results

Try this. I haven't put them on separate pages but they are in separate sections so you should be able to proceed from here

Hi Minty, I did the compact and repair and no difference. I then checked to see what version of access I was saving the database as and found I only had 2000, 2002-2003 or 2007. I am running Office 2010 on Windows 10. Decided to move to Windows 365 which allowed me to save it as Access...

Hi There I seem to be unable to do a DLookup in a query. I have a separate database to the one shown and was experimenting on using DLookup in a query. Unfortunately it failed with a message "Undefined function 'DlookUp' in expression" This has had me stumped for a few days after checking...

How do i mark a thread as SOLVED?

Hi Bob, Many thanks for the quick turnaround and a great solution. I had to modify code to accept Period key if I wanted to default back to todats Date. (Thanks MajP) Cheers Public Sub DateAdjKey(KeyAscii As Integer) 'Subroutine to Adjust Date Field up or down. Const conPlus = 43 'the +...

Hi There, I am trying to clean up repetitive code in an application I wrote many years ago. So far this process has been working well for reducing repetitive code volume and making the application easier to maintain. But I am having trouble with the attached Subroutines that I would like to...

Hi Isladogs, Thanks for the feedback. I double checked and the figures I quoted were Mbytes not Kbytes. Apologies for the confusion but I was writing the note at about midnight last night. I will followup on the suggestions that you and others have made! Cheers HB

G'day, I have built a multiuser, database over many years and split it into Front-end and Back end data bases. The backend is currently 68Kb and the front end is 220KB. I have compacted both Front end and back end databases weekly and it is stable. However I think the front end should...

Hi MICRON, You are correct. I omitted the ? from those lines and it worked perfectly. Apologies as I don't use the immediate window very much. Cheers and thanks again for helping and more importantly helping me understand why the command sequence did not work. HealthyB

Question how do I mark this problem as solved or fixed and also thank you?

I am running two monitors and changed both of them and hey presto it moved the title bar of the window back onto the viewable part of the screen. I then attached the properties window to right hand side of the design view window. So it is fixed. Thanks ever so much :)

Hi thanks for your help. I did as you said and got the following results:- ?commandbars("property sheet").left 566 ?commandbars("property sheet").left=650 False ?commandbars("property sheet").top -87 ?commandbars("property sheet").top=50 False ?commandbars("property sheet").top=200 False...

Hi I have a similar problem in that the 'Properties Sheet' Form and the "Add Existing fields" form are off the form or query that I am designing. As I cannot reach the title bar on the form I cannot move it down. I can resize it but not move it down as per attached screen capture. Any ideas on...

Thank you again. How do I mark this problem as SOLVED?

Thank you ever so much. The latter part of the thread you sent did the trick as far as the line spacing goes. The size of the text and icons on the 4K Dell laptop screen is reduced somewhat but at least I have a work around.

I'm not sure why but entries in my Navigation pane seem to have double or triple line spacing as per attached. What do I need to do to reset same to single line spacing or reduce the size of the font so that I can get more lines of tables, queries etc in the Navigation pane? I assume this is a...

Problem Solved!:) Whilst talking to a mate I asked him if I could try running my program and edit forms and the attendant data source queries for the forms on his WIN 10 - Office 2010 system. Low and behold the problem disappeared with no memory errors. My system is WIN 10 - Office 365. The...

I seemed to have found the problem. Quite often on a form I would use a pre-existing query [qryEmpTimesheets] to select say an Employee and their weekly timesheets from two separate tables [tblEmps] & [tblTimesheets]. This query may be used for several reports and forms depending what data I...

Hi JHB, Sorry for the delay. I have definitely established that the fault DOES NOT occur on 3 different PC's running Win 7 and Office 2010. However on the Dell laptop it fails when you go and edit a form where you try to modify the query for the data source for the form. I also decided to make...

Hi All, I did some experimenting and the program runs and works on two PC running Windows 10, Office 365. BUT I get the same Memory error when modifying a forms data source which is a query. I then loaded the program on two older Windows 7, Office 2010 PCs and the program works and the form...