Search results

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...

I'll try same tomorrow and get back to you. Excellent suggestion! :) Regards

Hi Doc, Here is some of the info you asked for. I increased the virtual memory size, then rebooted. I opened the form in Design mode and still received the previous error. :banghead: Do you have any other suggestions please?

Thanks for the info on how to get to MyComputer. Here is the CPU count

Hi there, Not sure how to find myComputer on Windows 10? (Ex windows 7 person) Memory should be ok its a 6 core intel factory supplied Dell XPS 15. So memory and SSD were installed by DELL. I have attached a snapshot of my processes if it will help

Hi Mike, Yes pretty much as if I normally modify something, I then save it and then test same rather than do multiple changes at the same time. Upon checking it would appear that I am getting the problem less often if the data source is simply a table, but errors occur more frequently when...

G'day, I recently replaced my old DELL pc with a new one with 16gb of Memory and 512Gb of Solid state drive. I have effectively doubled the capacity of the old PC in both memory size and SSD storage. I am running Office 365 / 64 bit and Access 2016. Error seems to occur when editing or...

Thank you ever so much. I did not know that there was a property sheet for the table. Setting it to "None" did the trick! Please ignore my second post and many thanks :)

I decided to make a copy of the tblJobTitle table called tblJobTitlecopy and then deleted the original table "tblJobTitle" Then I reopened the employee table and the + signs were still there, but when I clicked on same I got the following error message [The table or query name "tblJobTitle"...

G'day, I had a relationship between my Employee file and another 1-Many file (tblJobTitle) in my relationship diagram. So when I open the Employee file I have records with a plus (+) sign on them. When I click the + on one of the records I can see the related tblJobTitle records. After some...

Sorry folks I just found the problem resolution at this address. https://superuser.com/questions/1111914/windows-10-changed-how-quotation-marks-work-how-do-i-fix-this Cheers :)

G'day, I have just upgrade to Windows 10 and office 365 due to the old system dying. I am experiencing lots of bugs coming to grips with the new Access. One annoying bug is that if I want to specify a string like "tblEmps" I do not see the first set of rabbit ears as I data enter the double...

Thanks Jiri, I achieved the result I wanted using one query and then another based on the results of the first query being True or False. Messy but it works correctly. I might have a look at doing it using a DLOOKUP to see if I can select correct wage rate using weekly timesheet date and...

A clarifying question if you will. Assuming that the employee has an increase this week (21/Jan/19) and her wage goes from say $20 to $25/hour then her CURRENT wage rate would be set to $25/hour. If however I go back two months and edit or add a timesheet for that employee her wage would need to...

Hi There, Many years ago I developed and I am still running a basic payroll system, At the present moment I have all the standard employee data fields and the system has been running well for many years. However I have a question, currently each year we hire several new hires and over the years...

Hi Colin, I was aware of that gotcha and discovered same several years ago. But thanks for advising me of same.

Hi Colin, Many thanks for your prompt response. I am glad to hear that I am not the only one to have suffered as a result of using the standard split form. I'll go through the suggested link and examples today and see what I can do. Once again thank you! HealthyB

G'day, I have created a split form using the access 2010 standard form creation wizard and it seems to work ok except that the database form is too wide. The data entry form is ok. I have been fooling with it for quite a few hours without much success. If I try to edit the form it shows me the...

G'day, I have created a query in query design view and it works ok on the two tables I am using. I have now added an extra field to one of the two tables (tblVehicle). If I drag a new copy of the table into the existing query in design view it is now called (tblVehicle1). Examination of same...