Search results

I am trying to link to Access XP tables from an Access 97 database. They were linked before but we have changed the paths and will not update because of 'unrecognized database format.' How do you get around this? They were linked so I know it can be done! :eek:

I have a form that is based on a query that requires the user to choose a start date and end date for the data to display. The query looks to the text boxes on the form for the criteria for the date field (between .... and .....). For some reason, when you select the same start and end date, it...

Yes. I even checked the variable value to insure that it was passing the right control name. Any other ideas??

I have created numerous databases using pop up calendars but my current problem has me stumped. It's probably something simple and if so I plead end of week fatigue. I am using Allen Browne's calendar to populate a text box with a date. The calendar appears to work fine but nothing is showing in...

This may be a real dumb question but is there any way to view/edit an existing export specification for the transfer text macro? I'm reviewing someone else's database and can't figure out how to view it.

Thanks Pat. As always, I appreciate your advice. What I'm actually looking to do is find a way that , if both BE and FE are always in the same directory, the links will be maintained, even when moved. Is this possible?

Is there a way to define the link in the front end of a database to the tables in the back end where regardless of the directory/drive the database is placed in, the links stay intact? :confused:

I have a database with a form using tabbed subforms. Obviously the forms are linked using the LinkChild/LinkMaster etc properties. The problem comes in when I add a button to add a new record or when I try to add a combo box to bring up existing records. Use of either of these results in an...

I would really prefer to head this off at the query level because the Account number will show regardless of data assigned to it. What I'm really looking for is maybe a criteria to put in the query where I can link all the month fields and if all are null then the record is ignored.

This is likely a no-brainer but for some reason I'm hitting a wall on this one today and don't have a whole bunch of time to figure it out. :confused: I'm running a query that sums a large set of financial data. If all account numbers are listed in the report, the report comes to about 750...

I switched it to a FE/BE and it's still doing it. Anybody have any other ideas??

No. Compact on close option is not checked.

If by chance they were editing the same record would it do this??

I created a relatively simple database that allows several managers to enter their budget data for the coming year. The accounts are such that they should never be editing the same record. (An account number belongs to only one department). It is a single, stand alone file and not a split...

Ken - It's MSysDb not MySysDb. Do you see that one?

Other queries also give me that error. :mad:

I have a database that I created some time back and has worked fine for months. This morning when I tried to run one of the queries it said that it could not find the MSysDb object. :eek: If I'm not mistaken, this is one of the hidden system objects, right? What would make this object disappear...

I have a form that query's the operator for input values. They then click on a button on the form that runs a series of queries culminating in a make table query that contains the desired data and then displays this data in a continuous form that pops up. There WILL be times when the returned...

I found a way around the problem although I still would like to know why this occurs. The solution was to replace the .MoveLast with .MoveNext and then put in the code: If Not rstCBSisters.EOF = True Then rstCBSisters.MoveLast End If I appears that if the pointer is at the...

Thanks for your input but I don't think that is the case for two reasons. First, the recordset it is reaching the end of and hanging at is actually considerably larger than the other. Second, the way I have it written (I think) is that it steps one record at a time down the rstCheckInfo...