Search results

Hi, I am trying to have cascading forms running on my database. The first form adds a new staff member. When you press the next button this happens... Private Sub Command12_Click() DoCmd.Close DoCmd.OpenForm "Frm2" End Sub But I want it to open Frm2 using the ID from the previous form. The...

Hi Simon, Unfortunately I am using access 2003. Cheers, Paul

Hey, I am looking for a way to store thumbnail images for specific records. I want an idiot proof way of selecting a jpeg image and then storing a 200x120px bmp version of the file in the database. Is this achievable with VBA code? Cheers, Paul

Hi, Just wondering on how I would link to jpeg files and have access render them. No idea on how to do it. Cheers, Paul

How do you render them automatically? And thanks for the reply :)

Hi, I have a form for adding new records. They are for people and I add in a bmp image of them. I want to create an automation. Where you press a button to add a photo. Find a jpeg you want. Then it is resized, converted to bmp and saved in the database. Is this easy enough to achieve? (size...

Hi all, Got a problem with a report im running. The table has memo fields to cope with the amount of text (cause it may need to go over 225) but when I run a report based on it it cuts the data short. The table in question is TblMedication The query is QryMedsFurtherInfoSheet The report is...

Ahhhh now I get it. Thanks

Here is the database. The reports are there to see what I mean

Yeah I had to make it text as I need to put in 1/2 values too

Hi, I tried that but it only works if its a number value apparantly. The Iif statement fails in the query... Data type mismatch in criteria expression Cheers, Paul

Hi, I am running a report based on a query for a bunch of people who take medication. It runs the report and puts page numbers in the bottom right. Works perfect but I want it to do page numbers per person rather than the whole report. Is that possible to do or would I need to run some code to...

Hey, I have a report that is based on a query I have made. It currently shows the values as kept in the table. It is for a MAR sheet. Here is how it looks... Breakfast 0 Lunch 0 Teatime 2 Bedtime 1 I want it to show blank for each 0 that is shown. I have tried...

Sorry, I didn't explain myself too well. For a change! :) I want to show the fields but replace the "0" with "" Cheers

Pr2-Eugine: Do you mean only set up number columns in tables and build the relationships manually?

Hi, Am trying to export an excel (97-03) file from a query I have. Some of the columns have exported as number values (as its linked via unique id's). I want it to export certain columns as the text columns. I have tried the lookup route but it doesn't seem to make a difference. Any ideas...

I have a report that I had set to not show 0 value when it was a number field. I have now changed the field to a text field (don't ask) but I need it still not to show thw value if it is 0. How do you do that? Cheers, Paul

I would want it the notes column says sick that it removes the pay. But if it says sick for the same staff member for over 3 days that it divides the full pay by half. Cheers

I should say this needs to happen in the query QryDeductionsandSleep Ins.

Hi all, I'm making a database that pulls data from a CSV file downloaded from a website. The data holds information on which staff member has logged in or out at work. My database analyses this and tells us when staff have done a sleep in shift and subtracts breaks based on clocking in hours...