Search results

Hi! Thank you so much. It worked! :)

Hmm. Actually, I spoke too soon! HAHA. It didn't work. I was able to change how it looked on the Field List but Access tells me that there is no such field. I couldn't understand though how to execute your instruction. How do I make two columns from a Field List?

Hi! Thanks for your reply. I was now able to solve it based on the instructions from: http://bytes.com/topic/access/answers/881729-have-combo-box-list-field-captions

Hi! I'm trying to sort and filter a continuous form. I want to sort by descending and ascending, but I also want to have a combo box for filtering. For example, there a combo box for sorting with Value List as the RowSourceType, the list would be "Ascending" and "Descending", and there should be...

That just leaves me no choice. :( I guess I'll just make do with what is there. About the picture, do you think it would be logical to create another table with the following fields: I really don't want to give up the picture. But I will also try your advice. :)

I have another problem. The audit table on t_Department works, but t_DSPN and t_Employee don't quite work as I expect them to. I've managed to figure out the problem with t_DSPN. I couldn't make the audit table work because it has a multi-value field. As for t_Employee, it didn't work because of...

That was a prompt response. Thanks! I'll try it right away.

Okay then. I'll get to it. Thank you! :)

1. I'm using a Macro: RunMenuCommand Command RemoveAllSorts 2. Is Alias the same as Caption on the query? Or are you referring to something else? 3. Okay then. Thanks. :)

I am almost finished making a database for our HR department. I just have a problem with reports. Here's my sample database: http://www.access-programmers.co.uk/forums/showthread.php?p=1410980#post1410980 Please ignore the rest of the posts. My problem is this: I have created audit tables, If...

Hi! I sort of forgot how the errors popped up. I will update as soon as I figure it out. HAHA! Anyway, I'd like to ask you about something else that I've posted. Perhaps you haven't seen it. Anyways I'll repost it here: I've already got my audit table. I just followed Allen Browne's...

Hi! I got it to work. Though now, I have a new issue. I have no idea how it happened. So I've already gotten the sort and filter to work. I put a command button to do a remove sort/filter but when I try to click it, Access just tells me that it "isn't available now". Also, as for cboFilter, I...

Please see my HR database so far... The following are things I still need to look over: This error: Program crashes for some unknown reason Filter asks for parameter value Presenting the audit table on a report

Hi Gina! 1. So about the reports... I've already got my audit table. I just followed Allen Browne's instructions (http://allenbrowne.com/appaudit.html) so my table would basically look like the one on the site. It's really hard to explain my problem but I'll try my best to get it across the...

Hi! I have a continuous form based on a query for employees information. I already created a sort button with the following snippet for its macro: I did that instead of choosing "Field List" and choosing the query for its data because I couldn't quite figure out how to replace my actual field...

Hi, no need to apologize. It took me a long while to figure things out but I finally made it work. It's just that, I'm not exactly confident with the whole thing. I didn't quite understand the entirety of the codes especially with handling errors. I just did what I could minimally do and hoped...

Oooh yeah! I get it. Thank you so much! Will let you know how it works out.

Hi, I understand what you're saying. It's just that, I can't find the code for the log error function. Where is "below"?

No, and yes. No. I only copied here: http://allenbrowne.com/AppAuditCode.html I have no idea about LogError() or how I can incorporate it in the code. Maybe I didn't declare it or something that's why I keep getting errors. But I don't know how to fix it. Sorry, I'm really new. Yes, I made it...

Hi! I'm trying to construct a database that can keep historical data on employee details like previous departments, job position, etc. Sort of like an audit trail, but I want users to also see the data in a report or something. I've researched about this and even made a prototype using macros...