Search results

I am trying to trouble-shoot an issue with a Access 2002 database. Basically I have the database file shared out on a local network and there are 4 users accessing it. Well, there are using Access 2003 when opening the db file, but every time they exit the db, it is getting corrupted beyond...

Hi, I have a form with some fields on it, there is one called Pro Number. what I would like to happen is when a new record is created, it starts at a certain number and continues to increment by one. In other words, the first record would be 5600 and the next new record would be 5601 etc. I did...

Hi, I have a Form with three fields, the field called Profit is based on the other fields. Basically Field1 - Fields2 = Profit Field. That works great on the Form itself, but I built a new Query and when I tried to add the Profit Field, it returned now rows. My query is based on a start date -...

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

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

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

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

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

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

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

Could anyone give me some advise on the following: I have an access DB setup on a workstation, where several other PC's access the access application; basically network sharing. And aslo, we are doing this over DSL/VPN. The big question is, when DSL goes down, is there any way users would be...

I have a simple query, that I am using to select records based on a start date & end date. There is only 4 fields being returned: First Name Last Name Ticket Number Date All the data is coming back fine, but I would like to sort out records where the First Name & Last Name occur more than...

Not sure what the problem is, I have a access db I have been working on for a while that has a table for an auto number append query. The table has two columns, ID and PRO_HSTA, I am trying to get it to start with a particular number when creating records. It did work some time back, not sure...

I have a small query built and it is extracting the correct data, but I would like to take it one step further. I have two tables in the query and the following columns: Created Date (the criteria is using the between start date and end date function), First Name, Last Name, Ticket Number and...

I have a query I built from a single table, the data is coming back fine, but I would like to do a little counting of the data. I run the query with a date rangeand it does return all the data corrctly, but I would like to format it a little different. say, for example, I have a column that...

I have a general question about database splitting, I have searched the threads and really can not find an answer. I just finished up my access db and need to pass it to other users, only three or four users total. I am reading that splitting is the way to go with a FE and BE. Well, I used the...

I am trying to setup a button that would print a single record from a Form view. I have tried several different ways and none seem to work. I have the button setup now to send the single record to a Report and that works, but it is sending all the records in the database, help Thanks David

I am working with one Form and have setup some of the fields as combo boxes that use the row Source Type and Row Source Properties. It allows the user to type the first part of a name and finds the rest in the drop down list. Is there a way to have one field, (say for example the Name) lookup...

I know this can't be that hard, but I am slammed for time and need to find a quick way to do it. I have a simple form, that has an image(button)and a text box, that's it. I would like to be able to enter text in the box and onClick of the image (button) it searches my database for that value...