Search results

hello, i'm currently using this code to export an access query to excel, the query name is output_qry, it exports it to sheet1 and opens excel automatically. i have another access query that I want to export to the same workbook as sheet2. how can i do it. here is the code below that works for...

hi guys i'm getting an error msg number 3141 and been trying with no luck. Could anybody please help. below is the code. Dim RS As DAO.Recordset Set RS = CurrentDb.OpenRecordset("SELECT Count(request_tbl.request_tm_num) AS Ticket" & _ "FROM (SELECT DISTINCT request_tm_num, analyst_id FROM...

Hello, is it possible to create a vba code to make the data label color change based on the value. This is for a column graph in ms access form. I can format the data label or the column color based on series value. Thanks alot.

Hi I have a table in access with this format ID Grade 1 A 5 D 6 B 1 B 5 C need to write a query that produce the output like the format below ID Grade1 Grade2 1 A B 5 D C 6 b can someone please help, basically looks like the opposite of transform right?

hi guys, it's been a very long time :). I have copied this code from an old post. This code creates a query then it copies it to an excel sheet. The query works well when i open it manually, but the copy recordset and pasting to excel doesn't work. It opens excel empty. here is the code if...

Hi haven't been here in years. I actually have a question which might be complicated. So i'm importing to access an excel file. The excel file has 5 columns, each column has a header with values. For example. Truck Van Small Car Large Car 54 5454...

Hi, I have linked ms access to orcale to run a query, the date in orcale is in this format 20140101, i have tried to convert the date in the query like that but it's not working. format(mydate,"yyyy/mm/dd". Does anyone know how to do it. Thanks.

Is there a way i can convert the weekend days into working days for example. 5/4/13 1:30 PM is on saturday what function can I use to make this day read 5/6/13 8:00 Am which is monday. Same thing for holidays. Thanks.

Hi, Once I upgraded access to 2010 my frmcalendar doesn't work anymore, anybody has experienced this issue. It's still working fine for ms access 2007. Here is the function i'm using. Public gtxtCalTarget As TextBox 'Text box to return the date from the calendar to. Public Function...

Hi I have a memo field that contains model ID and model description and blank spaces ect... the data doesnt have the same formate in each raw, it's kind of messy, I'm trying to extract the model ID it's 8 characters long. Can anybody suggest a way? if possible do you guys know the function in...

I have a function that is calculating the hourse between two times, it's working fine for example time1 11:00am vs time2 12:00 pm, it gives me 1 hour, the only time it doesnt work is when the time difference is less than 1 hour, anything that is less than one hour i get 0, any advice? thanks.

hi, i have a column that has the date and time combined, how do i write a qurey for example to filter all records with time greater than 5:00 PM. I know how to do it if the time value was in a seperate colum for example > Timevalue("05:00 pm") but if the date and time are combined i dont know...

hi guys can somone help? I"m creating a dlookup query it only works when i inlude the value but not when i refere the value to a form. for example Nz(DLookup("[ID]", "[ID_tbl]" _ , "[Comments] like 'ABC'")) Is working but when i refere the ABC value to the form it's not working see below...

Hello, I have a module that copies a record then pastes into a listbox, is there a way to copy and paste multiple records or can i do it by pasting the second record by inserting a new line at the end of the used listbox? I know this is so confusing but any help would be so appreciated thanks.

I want to load multiple Ms-Exell files into Ms-Access table automatically through Procedure / Macros. The files will be in the same folder. How to do this process?. Can anyone help if you have done it in code. Thanks. "I already know how to do it thru get external data"

I hope that someone can assist, I know its probably a basic formula, but I cant' figure it out. I"m trying to get the total uptime for 20 devices per month. I have the total downtime minutes and total business time minutes, but do i have to consider the total devices in my formula!!! because if...

Hi, I have an acces form which includes a date field, date is always first day of the month, for example 4/1/09-5/01/09 ect... I want to make an unbound field next to it the relates to the previous date, for example if i have 4/1/09 I want to make the new unbound field show 3/1/09, i can't say...

Hi all, this might seem simple at first but it's really so complicated. I have a table that has records, there is a column for status. The table has like five different statuses. I have an account # feild and a statues field. I want to query all acount # that have two specific statues for...

I'm not sure if this is 2007 bug or issue, i've been using access for a long time, what i'm trying to do is modifying a combox query, so I put my expression then i save but nothing is saving, i come back to it and my expression is gone, anybody got a clue. thanks.

I have a field in a table that looks like this for example MNJUIIII#33, mnnn#2, i want to parse the number in the query in a new column like 33, 2 how do I do that? Thanks.