Search results

Thanks Pat :)

Hi I am creating rent software and I would like to do a running balance in a report. In the table there is a field called amountPlus and amountMinus Record one might have $10 in amountPlus making the balance $10 Record two might have $30 in amountPlus making the balance $40 Record three might...

The record (I believe) is added to the database after it is saved. Prior to the calculation of the totals, you need to do a save DoCmd.RunCommand acCmdSaveRecord

The key words to search for (in google) are dynamic web pages. ASP and ASP.NET seem to be the popular solution. I wonder if PHP is an option?

When closing an access database, I get the following error message: "There was a problem sending the command to a program" We recently had our server changed over. Is this an access problem, or their problem?

I am not sure if this helps, but I think you can only do an ORDER BY on fields you have selected. I cant really remember, but use the key word AS. Something like: SELECT DISTINCT (Format([Month],"mmm yyyy") AS month) FROM Table ORDER BY month; Soory I cant be more helpful

I am trying to use the runsql command and I am encountering a strange problem. The following works: DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" &...

I have searched (not knowing what to search for), tried Access help and most importantly experimented, but alas no luck. I have a header section and body/main section of a form. I want the background image to fill the body/main section only, but instead it seems to cover the whole form...

I think the answer is in your question. AND fieldName NOT LIKE 'Retail*' AND fieldName NOT LIKE 'FTM*' (etc...)

Worked perfectly. Thank you.

Not sure what to search for so I thought Id write a new post: I have a combo box which selects 3 items- Primary key, Surname, Firstname After an item is selected, the fields are populated according to the item. Since there will be many records, it would be nice if the user can begin typing...

I want a report that has 4 different sub reports. Each Subreport will have a total. Then on the main report, I want the total of all sub reports. Is there a way I can get at each subreport total, or should I code it or include the totals in the main table?

I am pretty sure there is no way. I read on the Microsoft site somewhere a solution that was a messy solution that they didnt back entirely. I guess one way would be to do your own auto number system using visual basic coding, and adjust the numbers with some sort of a loop as needed.

OK, it is a form bound to the staff table. There is a field in the staff table called textcolour. But textcolour is not present on the form. The other thing is: I never had any trouble with this form whatsoever until I added two more fields to the table, made them visible on the form, and...

1/ The manager doesnt understand front end back end. He also sees terms like a 'web page' as a buzz word. You know the feeling you get when you have your very own web page and you say to everybody 'Hey guys, I have a web page!'. Its that kind of mentality. For reasons far too difficult for me...

I have a program that works perfectly. It is in use, so I have done modifications on another copy of it. Tomorrow morning I want to copy those forms across. I did a trial run and I get an unusual error: "The expression OnActivate you entered as an event property setting produced the following...

Yes, it is a learning curve. Its like, OK, Ive created this database in access, now how to I make it work on the web. Look and feel. I dont want to compromise all the things Pat mentioned above simply because of look and feel. Its kinda a buzz word. They throw around terms without...

Yes, this is an ASP question, but it is also an access question. I have finished a database, but it is more of an application. It is heavily reliant on visual basic and controls. I am happy with it, The manager thinks it should be a web page (??) I know ASP can interact with Access and be a...

volString = Null 'String to hold the volunteers that have been processed docmd.setwarnings false 'Cretae a loop, we'll do our own exit condition later Do While 1 = 1 'If the volString is not empty, we check for volunteers NOT processed If IsNull(volString) = False Then getvol...

Hmm...Ok, try this Have a number field identifying each record, which is unique (ie- auto number). Then do something like 'This gets the total number of rows rowsNumber = dlookup("count(number)", "myTable") 'This calculates how many rows makes up 8% the8 = rowsNumber * .08 'This calculates...