Search results

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

Query Jack, bare with me here, I am new to Access......I am not sure I understand the totals query, can you expand a little on that process? Thanks

Query Jack, it is not duplicate data, what we are trying to do is, see how many times a customer calls in a given date range. Each record is a separate tickets. So each First Name/Last Name could have many records, but they are treated as individual tickets. Hope thats helps Thanks

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

Pat, This is a new DB and I want to start at a designated number, like 2245. That is for the first record I create in the db.

Autonumber Hey Pat, well, I am trying to start a new record with a certain number, that's it. David

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

Well, I created a new field in my query and added the criteria: MoreThanOne: IIf([FullName] > 1, "Yes", "No") but as soon as I step off the field I get an error: The Expression you entered has an invalid . (dot) or operator or invalid parentheses. You may have an invalid or typed parentheses...

The ticket number only reprersents a unique number for each call that comes in, not how many times a customer calls in. I am trying to sort out the single calls, only want to see if a customer has called in more than once. Hope this is a little clearer, thanks for the quick reply. David

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

DBL- Thanks for the advise....I will give it a shot. David

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

Lookup Fields I think we may be using a different version, I don't see the items you talked about. What I did was double click on the Name field and looked at the Row Source Type=Table/Query and Row Source=SELECT PRO_HSTA.CARRIER, PRO_HSTA.CARRIER, PRO_HSTA.CARRIER_ADDRESS...

Lookup Fields Alexandre- The click on option you talk about in your reply, is that the field property you are talking about? If so, should I just build it to to run the custom query, but I am a little confused about how the data is being passed back to the form? Can to expand a little on your...

Thank You That worked like a charm, thanks a million..... David

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

This is what I am using now, code wise: Private Sub Image42_Click() Me.Text40 = "" End Sub Private Sub Image44_Click() DoCmd.OpenReport "SIEBEL_S_ORG_EXT_GetValue_SiteID", acViewPreview, , "[SIEBEL_S_ORG_EXT].[LOC] = '" & Me.[Text40] & "'" End Sub And it is not a problem, I am just glad to get...

The clear function works great, thanks. When I added the pop up message box to my code, really all it brought up was the number I typed in to search for. But, still have to hit my enter button to make it work, go figure. David