Hi all
I have this strange problem that I was not able to resolve by my self.
I had my table and input form created and it was working fine until I have created a query, now I'm not able to amend or input new records at all.
How can I resolve this please?
Dan
Are you able to upload a copy of your db with minimum number of records. Make sure any confidential information is dummied up. Run a compact and repair and then zip the file before uploading to make sure it is small enough for this site to accomodate.
I have not heard of this situation before and will need to analyze the db to see what specifically is happening. Difficult to determine what is the causation without seeing the db.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you for your help.Originally Posted by alansidman
This problem exist only when I create query, I need this query as I have a costume formula in there.
Dan
Last edited by ciapul12; 05-14-2014 at 05:46 PM.
You will need to put the file into a zip file. The forum does not allow uploads of accdb or mdb files. Hopefully you have run a compact and repair also to reduce the size of the file before zipping it.
Hi Alan
Any luck with my db please?
Thanks
Dan
Dan;
Just saw that you had posted. Been busy. Will look at it as time available today and over weekend.
Alan
Dan, which form is your input form? I'm sure the form names are meaningful for you , but I don't have a clue. If it is the one that is used to Raise New Report, I think that I know the answer there. It appears that the record source for that is a query of the DataBase Table. If you want to use that as the input source you will have to bind it directly to the table. If that is not the case, then let me know. It is appears that it is currently set up as a means to just view data in the table and not make updates.
Last edited by alansidman; 05-16-2014 at 04:55 PM.
Hi Alan
There are 2 input forms, Raise new report and response form, there will be more as development progresses and I would like to know what is causing this problem so that I can fix it my self next time.
I appreciate you help :-)
Dan
Dan;
I looked at the properties for both forms. They have recordsources of a Query which pulls data from the DataBase table. If you change the recordsource to the table itself, then you should be able to add data to your tables. As an aside, why do you have two different forms updating the same table? Also, I was getting an error message when I attempted to open the Response form using the main form, it threw up a Macro error message. You may want to look into this. I don't use macros (only vba) so I couldn't diagnose the issues. Is there a reason that you have the recordsource a query and not the table itself?
Hi Alan
Thank you so much for taking time to help me I really appreciate this, I have 2 forms as this will be a program where users can raise new reports and respond to them. so manager raises the report and then employee responds to it in response form, the response form may not work as it is only a draft and not a final version I just put it there for reference.
I'll try your suggestion in the morning as it's already 1:13am here in UK :-)
dAN
Alan
This was it, my form works like a charm now after following your suggestion.
Thank you.
Dan
Dan;
Good news.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks