Search results

Hi I have a bit of a strange one.. Have to query a column in a table that is imported from an excel spreadsheet in to access. problem is a new column is added each week so the column name changes.. (I know really bad, but its what I have to work with from a 3rd party) The one thing that never...

I am trying to do a simple if statement (well probably simple for you guys) but im having a few difficulties. I want to check after update field If its after 16:30 and today’s date has been entered then display a msg box.. If before 16:30 and today’s date then no action and the same...

Hi guys, How would a go about creating a email using the data in from the current opened record. I am currently using vba code to create a pdf and send it via an email.. But I would like to place the required data directly in to the mails body.. Using me.'s. Your help would be really...

Required fields check with VBA Hi guys, I am building a database at the moment that requires some required fields... Problem is the form needs to be refreshed before the form is completely filled in which makes access prompt the user that all required fields have not been filled in.. Instead...

Hi I have hit a dead end. I am currently putting together a report that tracks all of our payments. I am having a few problems though.. I have my main table which includes cust's name, trans no, trans date, product, sku, and cost. I also have another table with field’s product, sku and cost...

Hi, I am trying to email a report based on the current record being viewed in a form. I have this so far but of course when the report is created it has all the records in it. Was wondering how I can create a report for the current record in the form. DoCmd.SendObject acSendReport...

I am creating a database for refund requests.. Sometimes the refund request can be duplicated so I have a query using " In (SELECT [OrderNumber] FROM [tblRefunds] As Tmp GROUP BY [OrderNumber] HAVING Count(*)>1 ) " to identify these duplicates.. I also then have another column called...

Hi, Sorry if this doesn't make sense.. :o Just building a database at the moment that logs conversations. I have one table called job data that holds job info such as job id, start date, end date etc etc.. Then another table linked with a relationship to this called convo data that holds the...

Hi, I have used a number of ways to lock down my database... 1 Disable Shift on start, 2 used xml to hide the qab and ribbon, 3 used vba to also disable qab and ribbon, 4 disabled access keyboard short cuts etc etc.. Problem is ones I use all these at once how will I be also to access vba editor...

Hi I have a table called "table1". within that table I have 2 fields.. "paymentdate" and "refunddate" I need to pull both these fields in to one field to consolidate all payment transactions and refund transactions for the current day in to one field. This data is then to be exported to excel...

Hi, In my database I have a payment amount column and a refund amount column.. I also have a refund required column.. If the refund required column is set to True then I would like to take the payment amount figure (say £50.00) and then place it in the refund amount column as a minus figure...

Hi, Im putting together a database at the moment which hold a lot of confidential details.. The info is submitted to the database and once used yes is selected from a drop down to confirm complete. What I would then like it to do is update a specific field(s) with a for example 4 *'s so the...