Search results for query: *

I am trying to use an update query with a field stone_code. In the update to area I have replace([stone]![stone_code],[forms]![frmStone Replace]![stone],[forms]![frmStone Replace]![newstone]) so in theory it should be looking at the field stone for whatever is entered in the form frmStone...

Hello, I have run the upsizing wizard but am not sure on what to now do. I know I have to link the front end to the backend but how do I do that. What files do I link them to/where are they etc. Is it the .mdf and .ldf files? If anyone knows of a document etc which has all the steps it...

I have just split my database which was working fine. I am now getting an invalid call error. Does anyone know of what may cause an invalid call. Is i possibly because when I reference my current db it needs to look at the split tables instead now or something like that. Any assistance...

I was wonderin if it is possible to sync multiple replicas at once or do you have to go through each one.

I have written some code to create a table of contents for a report I have created. I have code in the Detail_Print event so that as you move from the first record to the last record in the report it writes the page number and description to a table. Then I can use this table to show a report...

Hello, I have a query that selects data between 2 dates. Say the 1st of May and the 30th of May. The query works fine except that it does not select records for the 30th. If I want to select dates for the 30th I need to push it 1 day ahead. Is there a way of making the criteria inclusive?

I was wondering if it is possible to change the look of a form that is generated using the pivot table wizard. I can get the data etc that I want but I want to change the look of it. E.g the fields are all yes/no fields. I would prefer say to have them look like an option box where if it is...

I need some help with referencing a subform. I have my main form frmProductLine, in this I have a subform called frmProduct subform. I have entered the following in a field in the frmProduct subform : if (button = acleftbutton) then docmd.openform "frmcalander",,,,,,"frmProduct...

Hello, I have a make table query that gathers info from a table and makes a temp table that I alter and then append back to the original table. The problem is that once I have appended data back into the original table it duplicates the value - EmpID that I am querying on to create the temp...

Hello, I have access XP and I need to use the .edit option in a module. It does not exist though. I have editmode? and update but no edit. If I use tblName.edit anyway and compile it I get the error saying it is not valid and generally in the past I would just make sure the reference was...

I have a query that gets data from a form. This works fine but I also have 2 other forms that are nearly identical but I do not want to write a query for each form. So I have query 1 which has criteria [forms][frmForm1]![id] I also have form 2 and form 3. How can I use just one query to...

Hello, I need to find out a few things about data access pages. Basically are they capable of doing all the things that you can do in a form. E.g I want to click on a check box and cause an action to occur but I cannot find anything that looks like an access property. E.g On mouse down...

I need some help with outputting to HTML. Everywhere I have read says that none of the formatting etc comes through when you output to HTML. I have tested this and it is true. I need to be able to format data on the output to do conditional formatting, e.g if the value is 1 it will be red, if...

Hello, I have written a query that deletes a certain record based on some criteria. It is working great except for one issue. If say I want to delete 00101 product number. If there is only one occurance of this product number it will be deleted - this is fine, but if there are multiple...

Hello, I need to delete an amount off the end of a field. The amount deleted is variable. So I could have : description 0.01 description 0.101 description 0.1001 etc. It is always going to be 0.**** ( although on rare occasions it maybe 1.*****)- it will always have the . in it though. I...

I need some help with determining this week in a query and filtering it. I have a query with the fields : Year: Year([Tasks]![Date]) Date: Month([Tasks]![Date]) WeekGroup: DatePart("ww",[Tasks]![Date]) This works fine and with the other criteria in the query it will only return...

Hello, I am using the output to function to output a report to a directory. This is working fine except for 2 things. The report when opened in access has formatting where if the field is a certain value it will highlight in a certain colour. When I view the html format that is created it...

Hello, I am using the output to function to output a report to a directory. This is working fine except for 2 things. The report when opened in access has formatting where if the field is a certain value it will highlight in a certain colour. When I view the html format that is created it...

Hello, I need help with a very simple thing - I am having a mental blank. I have a table with a field that has a variety of dates. I have written a query that prompts you for start date and end date and it will select those records. Quite simple. What I want to do is instead of being...

Hello, I have a query that works no problem if I base it on criteria of a single value - e.g if it = ACDF. What I want to do is run the query based on a table of multiple values - so I want it to return only values where it = the values in a table. E.g ACDF, ANGUS, etc I keep getting a...