Search results

Not sure if anyone has done this, but I have an access database that collects accounting data. Is there a way to have that data pushed to Quickbook Pro or link to it some kind of way. This would save on double entries...I am not that familar with Quickbooks Pro, so kinda in the dark a bit...

Sorry, I was a little unclear on my question The query shows the data I need, but I don't want to see, for example 100 separate records for DAVIDD. I only want to see DAVIDD name listed once in the report and his total tickets for the month. Basically the query shows the data needed in my...

I have setup a new query and it displays all the data I want, but it is not showing up like I would like it to in the report. Basically, the query gets all the tickets from my DB for a given date range. I want the report to show something like this: USER: TICKETS...

Maybe I was not so clear That only gave me the first 25 rows, that is not exactly what I was looking for. Let me try this example: Say I have 100 tickets for this month, out of the 100 tickets, there were 20 for Call Type System Unavailable, 25 for 045 Error, 10 for PC Down, 1 for Monitor...

I am in the process of writing a query, but need a little help. We have a ticket DB, where users log calls for customer problems. Well, I need to create a monthly report for the calls. I have a field called Call_Type, which list all the possible Call Types, I would to be able to create the query...

thanks for the advise well, maybe on my next db, I will take more restrictions..... thanks again

I have just designed an Access DB for a Client, with the understanding that it would be used ONLY on one PC. Well, since then, my client wants to distribute the DB through out his company. I know each PC would need Microsoft Access, but my question is? How would I go about maybe licensing the DB...

One last question Everything seems to be good, except for one last item....After the message pops up and basically says you enter a duplication T#, the user clicks OK, but, then the window closes. Is there a way to keep it open so they could enter a good T# ? Thanks Again

Sorry, I missed that... Dah! I guess that's what happens when you don't get enough sleep... I will give that shot... Thanks Again

Additional thoughts I thought about the field name and did change it to T_NUMBER and added the [] around it. Well no more errors and if you type a T# that already exsist, it does not write the record to the DB. But, it does not let the user know it was a dup T# What is your thoughts on...

That did not work for me :( I tried adding this code to my Form, BeforeUpdate function. If DCount("[T#]", "CARRIERS", "[T#]=" & Me.T#) > 0 Then 'display message or something Cancel = True End If And when I goto to compile, it gives me this error: Compile error: Method or data member not...

Validate Field values The data is coming from a seperate table and I do have the T# filed set for no dups. So, I guess what I need is a way to let the user know they entered a dup T#????? Thanks for the quick reply, you guys/gals have the BEST Forum around....:) David

Hi, I have a simple form that users enter customer info on. One field is call T#, using Validation, could it check for dup T#'s ? after the user steps off the field? Currently, if the user enters a new record and using an exsisting T#, it does write the record to the DB; but you can't use that...

just to confirm Once I make my form additions, he will need to open his current copy of the DB and import the new objects? Correct? Just want to say, you guys/gals do a GREAT! job here... Everytime I have an issue or question about Access, 9 out 10 time I get a pretty good reply and quick...

I have an access db I created for someone and need to add a new form. Question is? he has given me the whole dbf file, but is continuing to add new records as I work on the other copy. My question is, how can I update the new forms without effecting his current data? Thanks David

I don't think that was the problem Thanks for the reply, but I don't think that was the problem....I did a search for missing references but did not have any luck resolving my issue. The problem is, someone else created this database and they disabled the menu items so no one could edit the...

I have an Access DB that when starting, none of the menu items are visiable. I did use the shift when opening the database and it prompts me for a password (and I enter the correct one), but none of the menu items are there. Whoever created it, must have locked out those items. My question is...

Forgot one question I have not verified this yet, but can users share the same replica DB or do they need there own copy and how does that work when they do updates? Thanks Again

I have an Access DB that is shared between 5 or so users. Several of the users are using VPN with DSL to connect to the db. I have created a replica of the DB and users work off of that when the DSL is not available, then update after wards. My question is, when one user has there replica open...

synchronize I found a pretty simple way yo do this, just want to run it by you. Basically I copied the original DB to My Briefcase and it created a Replica of the orignal, once users have the replica, they would be working against that copy and when they are done for the day. They can open My...