Search results

Thank you, now I've started to understand things... now it is easy to digest in parts. By the way, while i was waiting for replies i found this site... creating the same thing i was looking for with Macro's. Don't know how much control I'll have on Menu's when working with Macro menu's...

Thank you. It is a lot of code though. I never thought creating a simple menu with 3 4 options will be that complicated!!

I've searched over the internet but more I see, more I'm getting confused about which instruction to follow for the Right-Click Shortcut Menu. Could someone please guide towards the tested and working code, to do this right and easy way in VBA?? Thanks

Worked, Thanks. Another useful thing to know. Though there are no spaces in the table name and I reassured it, but there are two blank lines in results after table names when i use Debug.Print... maybe that was the problem!

I want to delete all records from all tables, but whenever i try the below code it shows me Run-time error 3131: Syntax error in FROM clause. Could someone direct me to the mistake I'm making please? Dim tVar As TableDef Dim strVar As String For Each tVar In CurrentDb.TableDefs If...

Thanks Bob, it worked. CJ, I'm running this query in After Update event. So it should do the thing. Spikepl, please be assure that every time i post a question i spend a considerable amount of time searching over the internet and I spend well above half day looking for this and apply different...

I've created an Append Action Query. When I run the Query when form "[Forms]![frmBoQ_Entry_Edit]"is opened and there's already a record, it executes correct and adds required records in sub form/table. But when i use the same query for a new record, which is basically what i want, in an After...

Sorry, the way I described the problem was not intuitive. I've got the problem solved. Thanks for help.

Append Query of mine is adding half records from another table in a table. For rest of the records, it shows the violation error as attached. Whatever the number of records are, it only adds half of them!! My confusion is, if there's a violation, then why it is adding half of the records and...

Thank you, this is something i was looking for )

But the point is to update the revision date automatically once revision check box is clicked and record is saved. How would I achieve that?

I'm trying to update a date field as soon as Check Box 'Rev._Date' change its status, checked or unchecked. But every time a write conflict box is appearing, attaching screenshot. Rev._Date is updated only if i press 'Drop Changes' button. Both check box and Rev._Date fields are in same table...

how good does this program integrates with MS Access? has anyone used it?? http://www.peterssoftware.com/las.htm looks like it is covering all my needs and will save me from lot of programming hassle, which is a trouble for me as an inexperience VBA Programmer at this stage.

How could i create username/password type authentication system in Access?? or anyone of you know of a helpful link in this regard please?? The book I'm following has got some old stuff, like for the above question it uses the "advapi32.dll" which is old school. Quick internet search says that...

Thanks, at least it cleared my mind from one angle. This was database will sit at the central server, like on MS SQL platform and there will be no need to implement SQL Server at each office?? Can we use SQL Server as back end to Access, if yes, how difficult would it be? What technologies do...

I've been posting questions recently in tables and reports forums on part of the project I'm working for. It basically is a project proposed by Costing and Planning department. I work for an Electrical contracting company in Oil and Gas industry. Now company wants to develop a database where...

Thanks plog, for your help on this query. Today i was able to complete the first part of big project and basic idea started from your hints )

Thanks plog, once again. I'll try that too, boss is getting flexible... but at later stages i need to build charts on these reports. Will I be able to do that with standard reports/queries in Access?

By the way, i was trying to convince my boss full day that experts are advising to use Excel for these kind of reports and seems like he has started to understand a bit and was producing different sounds in agreement. Hope he doesn't change his mind in the morning.

That is why i was requesting for alternative ways to represent these kind of reports so that I could use Access, but seems like there's nothing except Pivot tables that could help me around!!